>Hi
>
>I have successfully created a CursorAdapter class, using this tutorial: http://www.foxite.com/articles/read.aspx?id=49&document=creating-using-cursor-adapter-classes-a-simple-tutorial
>
>I can build the SQL statement on the fly, using the properties of the builder above, i.e. declaring the SQL command and sort/filter properties, I have placed the new CA with the data environment of my form, modified the data specific properties, and I have tested the connection. The new class works perfectly and returns the exact data that I need into a cursor that I can the bind to controls on myForm.
>
>However, what if I wanted to use SelectCMD to run an already created stored procedure with SQL Server 2005? The stored procedure has a parameter, CandidateID, so I'd need to pass that via SelectCMD.
>
>Regards

Check these two threads Re: CursorAdapter refresh from stored procedure Thread #1007506 Message #1007757
Re: Using CursorAdapter with CRUD Store Procedures Thread #952188 Message #952194