>>>>I have an application in which one of the modules is collections. Many times when a collection is made, the client sends the payment receipt issued by the bank by mail. And many times the user who records customer payments needs to copy the content of the email and many times the email contains writing with various font types and images.
>>>>
>>>>Is there any VFP control or ActiveX control that allows saving that type of content with a copy-paste, and what type of data should I create in the table so that I can save it without problems?
>>>>
>>>>As a back-end I use SQL Server through remote views.
>>>>
>>>>TIA
>>>
>>>I was researching a little and found that many years ago they used to use the Rich Text control. Is there any better alternative or should I stay with to use that old control? Also, my back-end is SQL Server, what type of data should I use? Varchar(max) or nVarchar(max) or Varbinary(max)?
>>
>>I've been using the RichText activex control in VFP, and using datatype 'text' (although I suppose varchar(max) would work too) in SQL Server to store it. So far no problems & been doing it for many years.
>
>Thanks Victor, so your apps have that copy and paste functionality? I hope I could have the time to do it. Any special condition to take into account when working with the Richt Text control? Besides that, what version of SQL Server do you use? On the other hand, in VFP what type of data should I use in VFP? Memo or Memo binary?
I do allow users to cut and paste into the RTF control. As far as version of SQL Server -- I've done this with every version of SQL Server released since 6.5 to the current version SQL 2022. in VFP I used the Memo datatype.
ICQ 10556 (ya), 254117