Hi Terry,

Wouldn't SqlPrepare() do what you want?

Regards,

Fernando

>My project has a UI that allows the user to specify or edit select statements (edit box and stored in fpt). A test button runs the select. If the return is ppositive, the select passes, if its 0 or less, a fail message appears.
>
>Running the SELECT actually creates a cursor based on the passed parameters. How can I run a select, without populating a cursor. The only importance of the test is to assure the syntax of select at the defined connection. Can a "fast" select (o rows) be issued using a count argument - or maybe stop after [just] pulling one row?
>
>Thanks