<< Click to Display Table of Contents >> Navigation:  Application development > Database driver characteristics > SQL drivers > SQL record modification requirements

The following requirements must be met to modify a record:

•The server must allow each operation. Security and capability are important: server views may not allow changes, and different types of modification are authorized separately.

•Views support insert, modify, and delete if allowed by the server. Queries do not support modifications.

•Record modifications performed within an explicit client transaction may require that a unique index or server ROWID exists on the table. For example, both DbiSetRange. and DbiGetRecordForKey require a current index. However, BDE supports the ability of SQL data sources to order records by any field without using an index on the server. A current index (for SQL data sources) can be defined as any group of fields from a specific table, whether or not a corresponding index exists on the server. BDE creates a pseudo-index by using one or more user-specified SQL fields to define the requested order.