By: Andy Deighton - andyxr
Quotation marks going weird
2003-12-05 08:48
Hi,
I am submitting the entire query string to my report and that query includes the statement, WHERE X="Hello". I am using double quotes (rather than single quotes) because my datasource is Access and it needs this. However, once that query gets processed by the report, that portion of the query ends up as WHERE X=[Hello]. Of course, Access (and any database) doesn't like this. Any clues?
Regards,
Andy
UK
Quotation marks going weird
2003-12-05 08:48
Hi,
I am submitting the entire query string to my report and that query includes the statement, WHERE X="Hello". I am using double quotes (rather than single quotes) because my datasource is Access and it needs this. However, once that query gets processed by the report, that portion of the query ends up as WHERE X=[Hello]. Of course, Access (and any database) doesn't like this. Any clues?
Regards,
Andy
UK
