258712_en-US

liliconcom

Execute SQL Question

If I have quotation marks for my SQL column names, what should I do when doing Execute SQL:

 

 

 

 

 

 

Re: Execute SQL Question

Use the special escape characters \[ and ]\ to surround your string, then you can have as many double quotes as you want.

sql_statement = 
"\[SELECT TOP 1000 [Test Number]
 ,[Test Type]
 ,[Ton]
 ,[Date]
 ,["OD Unit  Model"]
 ,["OD Unit  Serial"]
]\";
write(sql_statement);

Here's what shows up in the log window:

SELECT TOP 1000 [Test Number]
 ,[Test Type]
 ,[Ton]
 ,[Date]
 ,["OD Unit  Model"]
 ,["OD Unit  Serial"]