db_nextrow
acnet_status.i2.v = db_nextrow(handle.g.v, bytes_per_row.u4.v,
reply_buffer.g.v, bytes_returned.u4.r)
This routine reads data one row at a TIME from relational
databases. It requires an initializing call to 'db_select'.
Help with datatypes and creating tables is in intro_database.
handle database connection handle returned from
a previous call to 'db_open'
bytes_per_row EXACT size of each and every returned row
(sum of the lengths of all columns requested)
If 0, bytes_per_row from initializing
'db_select' call is used.
reply_buffer user's buffer into which the returned row
will be moved
bytes_returned number of bytes returned to user, 0 if
no more rows
Note on text/image columns:
See the description for the db_select function.
This function returns ACNET status values as follows:
SQL_OK success
SQL_SMALLROW success, but row is smaller than bytes_per_row
SQL_xxx database access failure
This function requires the following include files:
clib_h, acnet_errors_h
Related functions:
db_select, db_modify, db_open, db_close, db_error, db_free_image
C/C++ usage:
usage example