standard.db.sql.ODBCFetchForward

ODBCFetchForward is available since version 1.0.

Prototype:

boolean ODBCFetchForward(stmt);

Parameters

stmt

[in] the statement handle (or result set) as returned by ODBCStatement, ODBCListTables, ODBCListColumns, ODBCListTypes or ODBCExecuteQuery

Description:

This function should be used only when working with MySQL and tables that contain big text fields. A bug in MySQL will cause to return empty strings when trying to acquire data from such a field. In any other case you should consider using ODBCFetchNext and ODBCFetchFirst.

This function is used for compatibility only. Datasets that use this function WILL NOT BE ABLE to link to an object (via the DataSet property).

Another work around for this MySQL problem is to change the field type from TEXT to CLOB.

Return value:

Returns true if succeeded or false if failed.