Thank you Abdrew. This is really helping.

I am new at this. Can you give me a example of a SQLStringConnect?
This will also help me.

---

>Assuming you've established a connection to the SQL Server (with SQLConnect or SQLStringConnect) and stored the connection handle in lnConnHandle, you can use the syntax
>

lnResult = SQLExec(lnConnHandle, "exec MyStoredProcedure param1, param2, param3...", 'MyNewCursor')

>This will return the result of the SP into a cursor called MyNewCursor. If you omit the third parameter, the cursor will be called SQLRESULT.
>
>Cheers,
>
>Andrew
>
>>I have a Store procedure in SQL 2000 that process a large amount of data. The result of this SP is a sub set of data.
>>
>>How can I call from VFP my Store Procedure and get the result in a VFP cursor?