Comments in SQL statement

L

lavu

I am using VC++ in .NET 2003. Using a SQL ODBC connection to Sybase to
execute sql statements.
If I have commented out a part of the SQL , I get an syntax error from
the ODBC connection. I am using the Execdirect call.
However this statement runs fine on the direct interface to sybase
"dbisql".

Am I doing something wrong here ? I would appreciate any help here.
 
L

lavu

Never mind. I realised my parser was stripping out the new line
characters so the comments
appeared like valid SQL to the DB engine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C++ and ODBC ExecDirect() 0
SQL Server connection 17
How to modify the sql statement on a pivot table using VBA- XL2000 1
troubles with dns-less connection to sql 0
SQL syntax for Access Pass Through queries (ODBC) 4
Crystal Report error when using sql native client driver withunderscore in database name 1
Unable to update/add records in connected SQL Server tables 4
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1

Top