Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cut and Paste Causing Memo Corruption
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00956032
Message ID:
00956240
Views:
8
Hi Sergey,

I managed to get a copy of one of the users memos and I was surprised at the mess it was in. There appears to be memos from several different records amalgamated together. They are separated by a series of small squares which which I presume are 'unprintable' characters for VFP but which turn out to be a series of ASC(00) in my hex editor.

Also, there are a lot of memos in the table with a capital 'M' in the memo field indicating memos present, however when the memo is opened, it is empty. There are no VFP error messages coming up, yet. Whilst trying to browse some of the memos, I eventually come up with a 'Not Responding' message and I need to give VFP the 3 finger salute to close it down and start again.

I have screen print copies of one of the 'dodgy' memos and the hex print of it showing the invalid characters. I can send these to you if you like, or you can have a copy of the files (dbf and fpt) if you prefer. They are in a WinZip archive of about 855k.

Regards...Rex

>
>Can you provide more details on the memo corruption? What exactly gets corrupted? Do you get error VFP message or it manifests itself some other way? What do you see when you browse such memo?
>
>>
>>My users have reported memo corruption after using 'Copy and Paste' to select text from Web pages and paste them into my VFP application. This appears to be due to hidden control codes on the web page.
>>
>>Has anybody come across anything like this before? And if so, what is the best way to validate memo data so that only the 'raw' text is saved to the memo field once the user closes the window to which they pasted the text?
>>
>>I have set up a function call that checks every character in upper and lower case (A-Z), numbers, and certain formatting charcters such as CHR(10), CHR(13) but this does slow things down a bit when large chunks of text are involved.
>>
Rex Toomey
ISD Port Macquarie NSW
Australia

'Inside every older person is a younger person wondering what happened.'
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform