Hi all
I have this SQL in Report Manager. Using the old system of ODBC the SQL works w/o complaints. Enter OLE-DB the unmodified report same SQL won't work.
Error Generated:
SPACKINGLISTITEMS:SQL: GROUP BY clause is missing or invalid.
SQL Statement as specified in the Report Manager for SPACKINGLISTITEMS:
SELECT * FROM lv_LKsPackingListInvoice WHERE iPID = :iID
The following is the Database Conection strings passed and interpreted by reportmanager for OLE-DB, if there is some configuration mistakes I may have made:
Passed:
ThisForm.cntreportmanager.oleReportManager.setdatabaseconnectionstring("C04Data", ;
'Provider=VFPOLEDB.1;Data Source=' + ADDBS(goapp.cPathToDBC) + 'vso3.dbc' + ;
';Mode=Read;Password="";Collating Sequence=MACHINE')
ThisForm.cntreportmanager.oleReportManager.setdatabaseconnectionstring("C04Views", ;
'Provider=VFPOLEDB.1;Data Source=' + ADDBS(goapp.cPathToDBC) + 'vso3views.dbc' + ;
';Mode=Read;Password="";Collating Sequence=MACHINE')
Interpreted:
Provider=VFPOLEDB.1;Data Source=C:\VSO3\PROJECTS\C04\DATA\vso3.dbc;Mode=Read;Password="";Collating Sequence=MACHINE
Provider=VFPOLEDB.1;Data Source=C:\VSO3\PROJECTS\C04\DATA\vso3views.dbc;Mode=Read;Password="";Collating Sequence=MACHINE
These are the originally specified ODBC strings:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=C04 VSO3Data;Mode=Read
Provider=MSDASQL.1;Persist Security Info=False;Data Source=C04 VSO3Views
Please advise