Show TOC

sql_fetchLocate this document in the navigation structure

Use

Use this DBM command after executing sql_execute to display more result data in the same database session.

Prerequisites
  • You have the server permission AccessSQL.

  • You have executed an SQL statement (see: sql_execute). The keyword CONTINUE in the reply indicates that the results data has not yet been displayed completely.

Structure

sql_fetch

Result

OK

[END|CONTINUE]

[<record>

<record>

...]

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 the SQL statements

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