Board index » delphi » Strange characters hidden in memo field

AFM

Delphi Developer
Sun, 21 Mar 2004 19:00:22 GMT

Strange characters hidden in memo field

I am using a memo field in an Access 97 table to hold sql strings.  I load
these into an sql component at run time using a dbmemo field and an  asign
statement.  Sometimes the sql statement does not work and I get odd error
messages.

I have discovered by looking at the result of assigning the memo field to a
string that the following characters are being inserted in my sql statement
'#$D#$A' and are causing the problem.

Any ideas what may be happening ?

Anthony

 
Ivan Dimitro

Delphi Developer
Mon, 22 Mar 2004 01:06:49 GMT

Re:Strange characters hidden in memo field


The #$D#$A characters aren't strange at all. They are in practice "End of
Line" marker for each line.
Dagmar Silva dos Santo

Delphi Developer
Tue, 20 Apr 2004 10:45:43 GMT

Re:Strange characters hidden in memo field


Quote
"AFM" <t...@alltech.co.uk> wrote in message news:3bbb2c3f$1_1@dnews...
> I am using a memo field in an Access 97 table to hold sql strings.  I load
> these into an sql component at run time using a dbmemo field and an  asign
"AFM" <t...@alltech.co.uk> wrote in message news:3bbb2c3f$1_1@dnews...
> I am using a memo field in an Access 97 table to hold sql strings.  I load
> these into an sql component at run time using a dbmemo field and an  asign
> statement.  Sometimes the sql statement does not work and I get odd error
> messages.

> I have discovered by looking at the result of assigning the memo field to
a
> string that the following characters are being inserted in my sql
statement
> '#$D#$A' and are causing the problem.

> Any ideas what may be happening ?

> Anthony

Dagmar Silva dos Santo

Delphi Developer
Tue, 20 Apr 2004 10:44:54 GMT

Re:Strange characters hidden in memo field


o.k.
Quote
"AFM" <t...@alltech.co.uk> wrote in message news:3bbb2c3f$1_1@dnews...
> I am using a memo field in an Access 97 table to hold sql strings.  I load
> these into an sql component at run time using a dbmemo field and an  asign
> statement.  Sometimes the sql statement does not work and I get odd error
> messages.

> I have discovered by looking at the result of assigning the memo field to
a
> string that the following characters are being inserted in my sql
statement
> '#$D#$A' and are causing the problem.

> Any ideas what may be happening ?

> Anthony

Other Threads

1. D4: Strange characters in DBASE memo-fields

2. Help: DBMemo in character-field (not Memo-field)

3. hidden characters in Memo feild

4. strange characters at end of memo text?

5. Lost 1st 2 character in Memo Field

6. Text searching in character, memo fields

7. Hiding memo fields

8. #0 character in MSAccess Memo fields

9. Add character to Memo field

10. strange memo field behaivior