Clarion - Insert date with Topspeed ODBC

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Insert date with Topspeed ODBC

tleduc@gmail.com

2006-06-17, 7:56 am

I am trying to do a simple update on a date field using the Topspeed
ODBC drivers. Unfortunatley I have zero documentation for these drivers
and I believe they are some where around version 3. The field I am
inserting into is listed as DATE @D1.

sql: update ARRcptB set ReceiptDate = '7/06/06'

As far as I am aware this should work, but I keep getting and error
"Expected lexical element not found: <identifier>". I have tried
changing the delimiter, used double quotes, all sorts of weird
brackets, so on and so forth. Still no luck with the update.

If someone has any information that could help me that would be really
appreciated.

Sponsored Links