Library: Database access (OMDB)
Import : omdb.xmd
define external function db.delete from value db.table table where value stream condition
Use db.delete to delete records from a table using the supplied criteria.
The condition must be
The following example uses db.delete to remove grade references for students who did not finish a course. The deletion is performed through the db.table OMX component.
import "omdb.xmd" prefixed by db. process local db.database this-db local db.table student-course ; create the database OMX objects set this-db to db.open-odbc 'dbDemo' set student-course to db.open-table in this-db named 'StudentCourse' ; drop students who did not finish from course lists db.delete from 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'