AnsweredAssumed Answered

ExexcuteSQL() getting the error

Question asked by rosslare on Nov 30, 2017
Latest reply on Dec 1, 2017 by philmodjunk

Hi all,

 

I try to run the ExecuteSQL()  for generation  the Chart  through the data filtering.

 

Set Variable ($$Date1; value: "11/01/2017")

Set Variable ($$Date2; value: "11/30/2017")

ExecuteSQL ( "Select * from tblSalesInvoice2 Where tblSalesInvoice2::fldSalesInvoiceDate  >  =  ? and tblSalesInvoice2::fldSalesInvoiceDate < ?" ; "";""; $$Date1; $$Date2)

 

But I got the error message, "ODBC Error: [Microsoft]ODBC SQL Server Driver] COUNT field incorrect or syntax error."

 

Anybody can help ?

 

Thanks!

Brian

Outcomes