SQL Error

  • Thread starter Thread starter jamware
  • Start date Start date
J

jamware

I am trying to save custom reports to a table but I get a syntax error
due to the sinqle quotes.

How can I get around this error?

"INSERT INTO [MyReports] (ReportName, Report, Filter) Values
('test","CalDueListInfo_Query","(F12 = '21LR13' AND F22 = 'ON-SITE')")"

I want the User to be able to open saved report and apply the custom filter.
 
Back
Top