PowerBuilder ODBC error editing data in Access 97 tables

[DilbertPCer]

I have an ODBC connection to Microsoft Access 97 Tables fropm PowerBuilder 7.03.
However, when I try to Edit the Data of one of the Access tables from PowerBuilder it gives me the error
SQLSTATE = 37000 [ODBC Microsoft Access Driver ] Syntax error in date in query expression 'order#'.

SELECT orderid, order#,...rest of fields in query.

The Access 97 tables have queries attached to them in Access 97 .

This seems to indicate that the SQL of some of the queries in Access 97 is not compatible with a SQL query in PowerBuilder??

Thanks in advance for any help!

 

[PHV]

Have you tried this ?
SELECT orderid, [order#],...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DilbertPCer]

Thanks PHV! I'll see if I can modify the Access query to be more acceptible to PowerBuilder. I was trying to leave those alone; as somebody else programmed the Access part; but I'll see if modifying them will make a difference.

I'll also be glad to get any other suggestions for this problem from you and others.

 

[BNPMike]

The Access queries are not relevant. Your application is translating Powerbuilder SQL into ODBC calls which in turn access the Jet database. Your syntax is therefore the one that the Powerbuilder ODBC driver presents - check the documentation of that, although I would have thought it would be the same as ordinary Powerbuilder.

Some interfaces offer "pass-through". In this case the SQL has to be in Jet format. Copy the SQL into the QBE Grid of Access to test whether it works.

 

[DilbertPCer]

Thanks BNPMike!

I'll have to try that.
I'll also be glad to get any other suggestions for this problem from you and others!

 

[DilbertPCer]

To PHV:-
Thanks! ---Changing the query in interactive SQL will enable it to work; but I'm still left with the problem that ODBC doesn't do this for me!?