>Hi Cetin,
>
>I have used the cursor adaptor to execute the stored procedure. This works fine when no pararameters are expected by the stored procedure. How do I specify the parameters for the cursor adaptor. Here is example of my code.
>
>** create connecttion to database
>
>oRecordSet.cursortype = 3
>oRecordSet.LockType = 2
>WITH loCursor
> .ALIAS = 'mytab'
> .DATASOURCETYPE = 'ADO'
> .DATASOURCE = oRecordSet
> .SELECTCMD = 'select_mytab_1'
> .DATASOURCE.ACTIVECONNECTION = loConn
> loCommand.ActiveConnection = loConn
> IF .CURSORFILL (.F., .F., 0, loCommand)
> BROWSE
> ELSE
> AERROR(laErrors)
> MESSAGEBOX(laErrors[2])
> ENDIF
> loCommand.ActiveConnection = loConn
>ENDWITH
>
>Also, if i want to assign the returned data to textboxes and combos etc, how do I do that?
"Also, if i want to assign the returned data to textboxes and combos etc, how do I do that?"
With cursor adapter it's as if it was a native VFP table for you. As I see you aliased it 'mytab'.
You use mytab.fieldname as controlsource. IOW if you can natively browse it rest is how you would do with a native table.
Check:
Thread #
906520Thread #
944961 - here especially pay attention to Aleksey's messages.
Cetin