Comments in SQL statement

  • Thread starter Thread starter lavu
  • Start date Start date
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.
 
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
HELP PLEASE! I just want Column Names from ODBC 8
OLE DB Driver for .NET connection 1
How to modify the sql statement on a pivot table using VBA- XL2000 1
OLEDB / ODBC connection 2
CDatabase Transactions 3
Sybase doesn't allow more than one active statement when retrievingresults without cursor 2
SQL Connection Error with MS Access 7

Back
Top