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?