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?
Stuart Reid
True nobility lies not in being superior to another man, but in being superior to one’s previous self