GoFiler Legato Script Reference   Legato v 1.4j Application v 5.22b

Table of Contents	< < Previous	Next >>

 

Chapter Eight — Data Functions (continued)

ODBCFetchData Function

Overview

The ODBCFetchData function returns the content of the specified column for the current row within an ODBC Results Object.

Syntax/Parameters

Syntax

string = ODBCFetchData ( handle hResult, int index );

Parameters

hResult

A handle for an ODBC Results Object.

index

A zero-based int specifying the column index.

Return Value

Returns a string with the data for the column or an empty string if the column contains no data or on failure. Use the GetLastError function to retrieve error information. The GetLastErrorMessage function may supply additional information.

Remarks

Unlike the ODBCFetchArray function, the ODBCFetchData function does not adjust the internal position of the ODBC Results Object. This function is meant to be used with the ODBCNextRow function.

Because an empty result can indicate an error or that the corresponding column position within the current row contained no data, use the GetLastError function to determine if an error occurred.

Related Functions

ODBCFetchColumnName — Gets the name of a specified column by position.

ODBCFetchColumnNames — Gets the names of all columns in the Result Object.

ODBCFetchAll — Returns all rows and columns from the request as represented by the handle.

ODBCFetchArray — Returns all columns for the current row from the request as represented by the handle.

ODBCFetchBinary — Returns a handle to a Data Object for a column that has 'blob' type data.

ODBCNextRow — Moves internally to the next row within the Result Object.

ODBCQuery — Performs a structured query based on the connection handle and query string.

Platform Support

Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL

Legato IDE

 

Table of Contents	< < Previous	Next >>

GoFiler Legato Script Reference — Generated on 04/22/2024

© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.