Features

FOR UPDATE

The FOR UPDATE option has been added to implicitly inform Omnidex the a SELECT statement will be followed by an UPDATE or DELETE statement, allowing Omnidex to take the extra steps necessary to make the update possible.

If omitted, Omnidex assumes the current SELECT is for retrieval only and updates and deletes will not be allowed.

Update applications must implicitly specify that they are "FOR UPDATE"

• in the WITH options clause of a SELECT statement. This will apply only to this SELECT.
• in the Omnidex Environment file. Add and ACCESS <access option> statement to the Database section. This will apply to all statements processed against this environment.
• with the environment variable OA_DATABASE_ACCESS=ASSUMED_UPDATE. This will will apply to all Omnidex applications and allow existing applications to continue to function normally without making changes to the application or the Omnidex Environment file.
  

Top