OADELETEWHERE
oadeletewhere deletes a set of rows that qualify based on the criteria
you supply through the criteria parameter. By default, it automatically
updates the OMNIDEX indexes to reflect the deletion of a row. By default,
oadeletewhere waits until the file (table) referenced in table is accessible
then locks it. It then rereads the row, to ensure that it hasn’t
been updated since the fetch, before deleting it.
Syntax
oadeletewhere (cursor, options, status, tables,
criteria)
cursor -- Is a 32-bit signed
integer passed by value. This is the value returned by a successful
call to oaopencursor.
options -- Is a 256-byte
character string, passed by reference, that indicates the
action(s) for oadelete to take. Separate multiple options
with commas and terminate the option list with a semicolon
or a null character. The valid options are:
Passing a semicolon or a null character causes default behavior.
status -- Indicates the success
or failure of the oadeletewhere routine. A zero status.error
means a successful call to oadeletewhere. The status structure
is passed by reference and contains fourteen 32-bit signed
integers, followed by a 36-character buffer.
tables -- Is a character
value not longer than 33 bytes, passed by reference and terminated
with a semicolon or null character. Table contains the name
of the table where the row to be deleted resides.
criteria -- Specifies the
search criteria for deleting rows. Criteria is a character
value, up to 8192 bytes long, passed by reference, and terminated
with a null character or a semicolon.
Options
ODXID -- causes oadeletewhere
to delete rows that were qualified by previous successive
calls to oaqualify or oajoin from the specified table. This
is the equivalent of passing a $ODXID expression in the criteria
parameter.
Passing a semicolon or a null character causes default behavior.
Example
Top
|
