Background documentationdb_fetch Locate this document in the navigation structure

 

After having executed the db_executenice command with an SQL statement, use this command to display the next reply package containing more data of the result set.

Prerequisites

  • You have the server permission AccessSQL.

  • You have executed an administration command or an SQL statement (see: db_execute). The keyword CONTINUE in the reply shows that the data has not yet been completely retrieved.

Structure

db_fetch

Result

OK

[END|CONTINUE]

[<record>

<record>

...]

In the event of errors, see Reply Format.

Values for the Reply Fields

Value

Description

END

The reply was transferred in full.

CONTINUE

More data records are available but were not transferred due to the limited size of the reply package.

<record>

Result data of an SQL statement

The fields in a data record are separated by semicolons. Character strings are output in single quotation marks.