Name: MSQL::DATABASE-NEXT-RECORD
Section:
Msql Database Extensions
Synopsis:
<msql::database-next-record CURSORVAR [COLNAMES=NAMELIST] [PREFIXTABLENAMES] [PACKAGE=PACKAGENAME]>
Description:
Fill the variables in PACKAGENAME (defaulting to the current package if not supplied) with the values of the next record which last satisfied the search referenced by CURSORVAR.
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 these commas-separated list of names instead of the field names in the
result set.
<msql::database-next-record mydb cursor package=tmp
colnames="a.name, a.partnum, b.name">
<get-var tmp::b.name>
<get-var tmp::a.name>
If 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

The
META-HTML
Reference Manual V1.4
Copyright © 1995, 1996,
Brian J. Fox,
1996, 1997 Universal Access Inc.
Found a bug? Send mail to
bug-manual@metahtml.com