Jean-Rene:

Here are few code samples I pulled from an application I'm currently working on. Remember to test the result to make sure the command was sucessful.

*- Select SP, 'Cases' is the result cursor and lcCaseID is a parameter:
= SQLEXEC(oCMIS.ConHandle, '{CALL spGetCases(' + lcCaseID + ')}', 'Cases')

*- Insert SP, 'lcUpdateStr' is the parameter string thats generated by a method in the cursor object class:
= SQLEXEC(oCMIS.ConHandle, '{CALL spInsert' + THIS.ALIAS + '(' + lcUpdateStr + ')}')

*- Delete SP
= SQLEXEC(oCMIS.ConHandle, '{CALL spDelete' + THIS.ALIAS + '(' + ;
STR(EVAL('pk_' + THIS.ALIAS)) + ')}')

*- Update SP
= SQLEXEC(oCMIS.ConHandle, '{CALL spUpdate' + THIS.ALIAS + '(' + lcUpdateStr + ')}')

Charlie