D7, IB 126.96.36.199, dbExpress, Midas, 3T-CS
I'm trying to pass the following statement through my TClientDataSet
to an TSQLQuery:
SELECT FIELD1, FIELD2, 'VEGAS', FIELD3, FIELD4
When I execute this statement in IBConsole, it works great. The third
field is just a column of text that says VEGAS.
However this exact same statement causes an error to be raised in my
application. The text in the error is:
field name missing
I'm passing the statement thus:
var city_name: String;
city_name := 'VEGAS';
with cdsCity do
'SELECT FIELD1, FIELD2, ' + QuotedStr(city_name) + ', FIELD3,
Error occurs at the "Open" line. (Be aware that the CommandText line
doesn't word wrap in Delphi as it's shown in this email)
What am I doing wrong?
Thanks in advance.