Manual Page Viewer

THE META-HTML LANGUAGE REFERENCE MANUAL

[TOC]

Manual Page Viewer

Name: SQL::DATABASE-NEXT-RECORD

Synopsis:

<sql::database-next-record CURSOR &key [COLNAMES=NAMELIST] [PREFIXTABLENAMES=TRUE] [PACKAGE=PACKAGENAME]

Description:

Fill the variables in PACKAGENAME with the values of the next record which last satisfied the search referenced by CURSORVAR.

If PACKAGENAME is not supplied, then return an alist of the values instead.

Each subsequent call gets a subsequent record from the list of results, until all of the results are exhausted.

Returns true if there are any records left in the search results, or the empty string if not.

If COLNAMES is supplied, then the column values of this result are bound sequentially to the comma-separated list of names in NAMELIST instead of the field names in the result set.

 <sql::database-next-record cursor package=tmp
             colnames="a.name, a.partnum, b.name">
 <get-var-once tmp::b.name>
 <get-var-once tmp::a.name>

If COLNAMES is non-null, or the database connection option SQL-PREFIX-TABLENAMES is non-null, then for each column in the result set, use the column's table name, if it exists, as a prefix to the column name as the variable name.

Edit Pointer
Function Index
Variable Index
Variable Editor