Methods for performing Insert, Update, and Delete Operations

By default, GainSeeker uses one method to perform insert, update and delete operations on MySQL and on SQL Server 2005 and later, and it uses a different method for all other databases (including previous versions of SQL Server).

If you encounter problems or performance issues and want to try using the other method for these operations, you can add one of the following lines to Convert.db:

useqry=0

This method is used automatically with all databases except MySQL and SQL Server 2005 and later.

To use this method with MySQL or with SQL Server 2005 and later, add this line to Convert.db .

Note: If you are changing behavior of decimal and digit grouping symbols using the Control Panel, it must be set to 0 .

useqry=1

This method is used automatically with MySQL and with SQL Server 2005 and later.

To use this method with all other databases, add this line to Convert.db .