TADOQuery.SQL.Text - unwanted trailing characters

From: Ingunn (ingunn_at_duo.is)
Date: 12/01/03 

Date: 30 Nov 2003 16:02:08 -0800

Hi,

I have a TADOQuery object and am trying to set the SQL.Text property.

ADOQueryUpdate.SQL.Clear;
ADOQueryUpdate.SQL.Text := 'update TABLE set COLUMN = VALUE where
COLUMN = VALUE';

When debugging the ADOQueryUpdate.SQL.Text has some unwanted trailing
characters: 'update TABLE set COLUMN = VALUE where COLUMN =
VALUE'#$D#$A and ExeqSQL therefore causes an error.

How can I loose the #$D#$A thing?

Please advice what I am doing wrong.

Relevant Pages

  • Re: Text Box or String > 32K -- Problem?
    ... >lengths on various fields and objects while debugging the code. ... 120K characters will never fit into a text box. ... bridges an old A2 back end data mdb to an A97 front end. ...
    (microsoft.public.access.formscoding)
  • Re: I cannot reliably write the Hex number "83" to a stream
    ... ajmastrean wrote: ... transforms itself into "0x3F". ... For instance, debugging shows that ... Since you're writing text characters through an encoding object, it will in some cases encode the characters different than if you just output pure bytes to begin with. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Weird TraceListener NewLine problem
    ... debugging, I think the mail message should also contain the characters. ... Steven Cheng ...
    (microsoft.public.dotnet.general)
  • Re: Why does my program change the characters in my shell
    ... > I'd like to know what the typical reason for this is. ... However, when it gets done puting the data on stdout, the program is ... > characters, just right angled shapes and stuff. ...
    (comp.unix.programmer)