I want to create a qyery in MS Query using the SQL 92 driver but get a -20003 error. The field I query is called date and that is the problem I suppose. I can query all other fields, but this is a reserved keyword in SQL.
I tried to add brackets in several forms, but I don't get the query to work. Anybody any suggestions? Generating an SQL trace log didn't provide any additional information.
Tried:
Following kb article 18909
select "pub"."prhtrs".date from "pub"."prhtrs"
SELECT "date"
FROM PUB.prhtrs prhtrs_0
I tried to add brackets in several forms, but I don't get the query to work. Anybody any suggestions? Generating an SQL trace log didn't provide any additional information.
Tried:
Following kb article 18909
select "pub"."prhtrs".date from "pub"."prhtrs"
SELECT "date"
FROM PUB.prhtrs prhtrs_0