And it's not what Terry wants (
...The only importance of the test is to assure the syntax of select...)?
>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