F Fetch

Fetch one record or row.

Modes

  • Mode 0—fetches the specified record. It adds the address of the requested record to the hitlist, or the complete record to the select cache.

  • Mode 1—fetches the specified record with a lock. It chooses a DBMS lock which guarantees that the record can be updated and deleted in this transaction. Except for the lock, mode 1 is identical to mode 0.

  • Mode 2—depends on the type of DBMS you are using. For field-level DBMSs, the request simply returns, without doing anything. For record-level DBMSs, it locks the record without fetching it. The locking type is the same as in mode 1.

Conditions

The table for which the Fetch is requested is open.

Description

This connector request fetches a record from the table in the DBMS and adds it to the select cache, or hitlist.

When the complete primary key is available, Uniface calls the Fetch request without a previous Select. When the select cache is used, records are fetched without a call to the Fetch request.

If the DBMS supports different locking granularities (like field locking, record locking, physical page locking or table locking), this locks a single record if possible, or the smallest of any larger unit if necessary.

Related Topics