Embedded SQL

To request a cursor from an embedded SQL application, you specify the cursor type on the DECLARE statement. The following table illustrates the cursor sensitivity that is set in response to different requests:

Cursor type SQL Anywhere cursor

NO SCROLL

Asensitive

DYNAMIC SCROLL

Asensitive

SCROLL

Value-sensitive

INSENSITIVE

Insensitive

SENSITIVE

Sensitive

 Exceptions