RunQueryCheck

Syntax

SQL.RunQueryCheck(Query[, Timeout])

Description

Checks if a SELECT query for syntax and result.

If the query is good and the result returns at least 1 record found, the function returns TRUE, otherwise FALSE.

Parameter	Description
Query	A reference to a SELECT query.
Timeout	Optional. The number of seconds in which the test must be completed. If not specified, the timeout is 30 seconds.

See Also

other SQL.RunQueryxxxxxxxx functions.

Example

Sub Main()
 
    Dim sQuery As String
 
    sQuery = InputBox$("Select Query:")
    If SQL.RunQueryCheck(sQuery) Then
        MsgBox "Query is OK!"
    End If
 
End Sub