Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Interactive SQL options

auto_commit option [Interactive SQL] Next Page

auto_refetch option [Interactive SQL]

Function

Controls whether query results are fetched again after deletes, updates, and inserts.

Allowed values

On, Off

Default

On

Description

If auto_refetch is On, the current query results that appear on the Results tab in the Interactive SQL Results pane are refetched from the database after any INSERT, UPDATE, or DELETE statement. Depending on how complicated the query is, this may take some time. For this reason, it can be turned off.

See also