Subject | TIB_Query Programatically Defined SQL with Strings |
---|---|
Author | jrodenhi |
Post date | 2003-12-08T21:52:15Z |
I have been having problems with an update statement I am building in
Delphi that looks something like:
UPDATE MyTable SET MyField = 'ABC Company, Inc.'
I get an error that indicates that the parser believes I want to set
MyField equal to another column as though 'ABC Company, Inc.' is the
name of a column.
I can see that the customary way of accomplishing what I want to do
is to use a parameterized query. I may end up doing it that way,
but for now, am I missing something obvious?
Thank you for your help.
-Jack Rodenhi
Delphi that looks something like:
UPDATE MyTable SET MyField = 'ABC Company, Inc.'
I get an error that indicates that the parser believes I want to set
MyField equal to another column as though 'ABC Company, Inc.' is the
name of a column.
I can see that the customary way of accomplishing what I want to do
is to use a parameterized query. I may end up doing it that way,
but for now, am I missing something obvious?
Thank you for your help.
-Jack Rodenhi