| **Navigation:**  SQL Driver Strings(General) >====== VERIFYVIASELECT ====== | [[useinnerjoin.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[where 1.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

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

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

{{blk2blue.jpg|blk2blue.jpg}}

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.