Returns field value by it index.
Syntax:
property FieldValues[aIndex : integer]: string;
Description:
Use FieldValues to get value of field with index aIndex in active record.
▪All fields values are returned as strings when using TMySQLDirectQuery component for performance reasons.
▪NULL fields values are returned as empty strings. Use FieldIsNull method to distinguish empty string values from NULL values.
Use FieldRawDataPointer method if you need to work with BLOB fields.
Please read this FAQ section if you want to use Unicode strings in your application: How to use Unicode data in my application?
See also: FieldsCount property, FieldIsNull, FieldValueByName, FieldRawDataPointer methods