Stuart McLachlan
stuart at lexacorp.com.pg
Mon Mar 21 06:33:40 CST 2005
> > In my VB application I have a connection to the database inside a > funtion > called OpenDataConn and use the following code (dtKPIStart and > dtKPIFinish > are the start and end dates). > strSQL = strQueries(intQuery) & " '" & dtKPIStart & "', '" & > dtKPIFinish & > "'" > Set rsKPIData = OpenDataConn.Execute(strSQL) When I run the program I > the > following error message: > > Run-time error '-2147217900 > Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', > 'SELECT' or > 'UPDATE > Do a Msgbox StrSQL before the Set....and post the result. -- Stuart