dbTalk Databases Forums  

Error writing file - record not tagged with Formatted Memo

comp.databases.paradox comp.databases.paradox


Discuss Error writing file - record not tagged with Formatted Memo in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Tony McGuire
 
Posts: n/a

Default Re: Error writing file - record not tagged with Formatted Memo - 03-06-2009 , 09:32 AM






Jim Moseley wrote:
Quote:
Tony,

And my question is whether the data in these memo fields, or some of it,
is
from copy/paste from Internet pages or other applications.
A LOT of garbage, that the user can't see, is captured along with text when

doing copy/paste of text from Internet pages.


Good guess.

Jim Moseley
Not exactly a guess. I've seen it many times.

I believe that if you write the captured text to a textstream, then read back
out using a text stream, you get rid of the 'bad' characters.
Might be able to do this just copying from a memo var to a string var during
the capture process.

One of the worst things that happens during this exchange is that web pages
can contain NULL characters. Which trash fields of data. Even chr(13) or
chr(10) can make some data appear to say 'new record' when it isn't intended.


--
---------------
Tony McGuire
http://www.lostlore.com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.