Hi,
I have a query that i built in access as follows,
sp_RetrieveAllEvents=SELECT IIf(RecurrenceType='N','No','Yes') AS IsRecurrence, *
FROM tblEvents
ORDER BY EventStartDate;
this query updates tblEvents table in ms access. However, when I try to use it in a vb.net page with the code
Dim DS As DataSet = DB.GetDataSet("sp_RetrieveAllEvents"
i get the following error:
invalid sql statement:expected delete, insert, update, procedure or select.
any help would be appreciated.
thanks