Forums

This topic is locked

problem with stored procedure

Posted 10 Feb 2004 16:41:11
1
has voted
10 Feb 2004 16:41:11 tresa peter posted:
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

Reply to this topic