All SQLPrepare does is compile your code.

>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