M
Magne Ryholt
I am using the Jet 4.0 OLEDB provider with an Excel workbook as datasource.
The queries I use is listed in a range of cells in another Excel
workbook/worksheet.
This works perfect, however I would like to be able to use comments in the
SQL query strings for clarity,
of course I could remove the comments in my program before sending the
string to the db engine, but I guess there is a syntax for comments.
E.g. SQL Server has the "--" syntax and the /*..*/ syntax.
Anyone knows the syntax for Jet SQL ?
The queries I use is listed in a range of cells in another Excel
workbook/worksheet.
This works perfect, however I would like to be able to use comments in the
SQL query strings for clarity,
of course I could remove the comments in my program before sending the
string to the db engine, but I guess there is a syntax for comments.
E.g. SQL Server has the "--" syntax and the /*..*/ syntax.
Anyone knows the syntax for Jet SQL ?