>>The error i have is :"syntax error at end of input Error while executing the query Code: 1526"
>>
>>Thanks
>I've never used cursor adapters but if you manually run the modified command does it give you a syntax error?
Not too useful if it's only the fox side statement, which then doesn't properly pass through odbc. One needs a server-side profiler, and I've found the ExpressProfiler.exe (from some guy at m$, I'd say...) quite useful when running on a SQL server with single instance and single user - otherwise it's hard to filter out all the dozens of requests.
I'm sure some such tool must exist for postgress too - and being a postgres user now I would have probably already found it, but didn't need it yet. What little stuff I do in the database is coming from Python, and it doesn't have this kind of problem, being fresh and regularly updated. But generally I remember that sometimes the ODBC parser would interpret something in a wrong way and send it, and you wouldn't see it fox side, only on the other end of the ODBC connection. Luckily, the server logs every statement, so you can see what really got sent, and try that manually. Often just looking at it will show you what went wrong.