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 |