Clarion Community Help

DRIVER('SQL Driver', '/VERIFYVIASELECT = TRUE | FALSE' )

[ Verify“ = ] SEND(file, '/VERIFYVIASELECT [ = TRUE | FALSE ]' )

VERIFYVIASELECT lets the SQL Driver use an alternative, sometimes faster, method to validate fields when opening a table. By default (VERIFYVIASELECT=FALSE), the SQL Driver uses the SQLColumns function to validate fields. However, some backends (particularly SQL Anywhere) can validate fields faster using a SELECT statement. To verify fields using the SELECT statement, set VERIFYVIASELECT to TRUE.

VERIFYVIASELECT defaults to TRUE for SQL Anywhere backends.