Ok! That cool! I supposed you test the result of SQLEXEC?
What about a SortProc that return a result like 10 records. How do you retrieved the records?


>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