Other Library Functions

function

dbTableDelete

Library: omdb - high level database access Include: omdb.xin

Declaration

  define external function dbTableDelete
              value      dbTable   table
    where value    stream       where optional

Where:
table

A database table.

where

An optional condition to limit the number of rows deleted.

Purpose

This function deletes records from a table using the supplied criteria.

The following example uses dbTableDelete to remove grade references for students who did not finish a course. The deletion is performed through the dbTable OMX component.

  process

      ;  local variables
      local dbDatabase this-db
      local dbTable student-course
      ;  create the database OMX objects
      set this-db to dbOpenODBC 'dbDemo'
      set student-course to dbTableOpen this-db table 'StudentCourse'

      ;  drop students who did not finish from course lists
      dbTableDelete student-course where "Grade is null"

      ;  catch the database exceptions
      catch #external-exception identity catch-id message catch-msg
          output 'An error occurred while accessing an omDB function.%n'
          output '%g(catch-id)  :  %g(catch-msg)%n'

Other Library Functions    dbClose    dbExecute    dbFieldValue    dbIsVersionCompatible    dbLibraryVersion    dbOpenODBC    dbQuery    dbRecordExists    dbRecordMove    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

----

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ OMX ] [ OMX ] [ ERRORS ]

Copyright © OmniMark Technologies Corporation, 1988-2000.