Get Data Row (Results Menu)

The Get Data Row function tool retrieves and displays the data for every column in the current row of the result set on the current statement handle. You must call SQLFetch, SQLFetchScroll (ODBC 3.x), or SQLExtendedFetch (ODBC 2.x) before calling the Get Data Row function tool. The Get Data Row function tool performs the following actions:

  1. Calls SQLNumResultCols.

  2. Calls SQLDescribeCol to retrieve the name and column size of each column in the result set. Based on the column size, it allocates an output buffer of up to 65,535 bytes for each column.

  3. Calls SQLGetData for each column in the result set with a TargetType argument of SQL_C_CHAR. The Get Data Row function tool only calls SQLGetData once for each column. If the data is longer than 65,535 bytes, <trunc> is displayed before the first byte of data in the buffer.