VerifyQuery()

Summary

Verifies whether an SQL query has the correct syntax.

 

Changes

Added check for data type mismatches in Version 6.0/2012.

 

Syntax

VerifyQuery(string query)

 

Argument	Contents
query	The SQL query string

 

Example

qry = "Select * where Income > 50000"

on Error do ShowMessage("The SQL Query is not correct.") end

VerifyQuery(qry)

 

Notes

• VerifyQuery() checks the syntax and the presence of the fields, and whether there are data type mismatches.

Error Codes

Error Type	Meaning
Error	The query string is invalid
NotFound	No records were selected

 

See Also

Function	Summary
SelectByQuery()	Selects records based on an SQL query
SelectByQueryFile()	Selects records based on an SQL query that is stored in a file