File db.icn

Summary


 db.icn - DataBase convenience utility library

 This is mainly for backwards compatibility with early, experimental
 versions of Unicon's database facilities, and is effectively vestigial
 and obsolete at this point. You should probably just ignore this and
 use the interface described in the Unicon book.

 Having said that, the vestigial interface provided simple database
 access for folks who do not know SQL. They were a growing number of
 built-in functions before we had the stroke of genius to just provide
 a sql() function and leave it to the applications programmer. That
 allowed us to delete several built-ins and deprecate them down to being
 library procedures in here. There might or might not occur in future
 a motivation to resuscitate and enhance that API as a library. One
 surviving vestigial element is open's optional "default table" parameter
 that may be supplied prior to user and password. The "default table" is
 used in some built-in functions that turn information about column names
 and types and the like.

Procedures:
dbclose, dbdelete, dbfetch, dbinsert, dbopen, dbselect, dbsql, dbupdate

This file is part of the (main) package.

Source code.

Details
Procedures:

dbclose(db)

 old name for close()


dbdelete(db, filter)


dbfetch(db)

 old name for fetch()


dbinsert(db, rec)


dbopen(dsn, tabl, user, password)


 dbopen(dsn, user, password) - opens database connection, no default table
 dbopen(dsn, table, user, password) - opens connection, supplies default table


dbselect(db, cols, filter, order)


dbsql(db, sqlstatement)

 old name for sql()


dbupdate(f, rec)



This page produced by UniDoc on 2021/04/15 @ 23:59:54.