SqlCanQuery%

Cancels any rows pending from the most recently executed query.

Syntax

SqlCanQuery% ( sqlconn% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

Returns

SUCCEED (1) or FAIL (0).

Remarks

Use SqlCanQuery% to cancel any unread rows that result from the most recently executed SQL query. Calling SqlCanQuery% is the same as calling SqlNextRow% until it returns nomorerows.

The SqlResults% function must return SUCCEED before an application can call SqlCanQuery%.

To ignore the results of all of the statements in the command buffer, use SqlCancel%.

See Also

SqlCancel%, SqlNextRow%, SqlResults%, SqlSend%