Which SQL statements are supported by SilkTest DB_Tester?
The SQL functionality supported when using DB_Tester does not depend on SilkTest but rather on the ODBC driver that SilkTest uses to connecting to the database. The SilkTest DB_Tester facility passes the SQL string straight through to the ODBC driver and then any returned data can be processed using the various DB_Tester functions.
An example of this would be the Excel ODBC driver. SilkTest can UPDATE and ALTER any values that appear in the table but, due to limitations of the Excel ODBC driver, SilkTest cannot DELETE any rows or values from the table.