General information
Title:
ADO, CursorAdapters & Stored Procedures
Ok, there is what I need to do.
Using VFP Cursor Adpater, i need to be able to send call a stored procedure in SQL Server, passing parameters (1 or more) and having that stored procedure return a cursor with or without data, USING ADO (OLEDB).
Here is my problem, I can get all that to work, if I leave the nOption in CursorFill() (3rd parameter) at 1 or 0, if I try to change it to 4, all hell breaks lose. Below is my Select Command.
SelectCmd = "sp_Vehicles_Get ?vp_vehicle_pk"
When I run though the code, if I leave the nOption at 1 or 0, it runs fine and I get the data I expect. However, if I change the nOption to 4, I get the error: Microsoft OLE DB Provider for SQL Server : no value given for one or more required parameters.
the ADO Command "CommandText" was set to "{ call ntssp_JurorExcuses_Get ? (?) }"
One other thing, I have played with the "RETURNVALUE" type of parameter in the oCommand.Parameters, but when AfterCursorFill event starts, that paramter has been removed and only the single parameter the stored procedure is looking for is in the parameter list.
Anyone have any ideas?
TIA
Mark
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only