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