# MySQL\_GetStringValue

## `MySQL_GetStringValue` (FUN)

FUNCTION MySQL\_GetStringValue : \_\_XWORD

**Short description:**

> This function converts the requested field data and returns it as a readable value in "sValue".

**Detailed description:**\
To select the data from the response DataSet, you must specify the row number iRow and the column number iColumn. If you specify an existing row and column, you will receive the result as a string in "sValue".

**Attention:** Fields are limited to 500 bytes.

InOut:

| Scope  | Name                   | Type           | Comment                                   |
| ------ | ---------------------- | -------------- | ----------------------------------------- |
| Return | `MySQL_GetStringValue` | `__XWORD`      |                                           |
| Input  | `iRow`                 | `INT`          | Row index (first index starts at 1)       |
| Input  | `iColumn`              | `INT`          | Column index (first index starts at 1)    |
| Inout  | `stQueryResult`        | MySQL\_DataSet | MySQL query set                           |
| Inout  | `sValue`               | `STRING(500)`  | Query string value (limited to 500 bytes) |