DAC for MySQL

TMySQLDatabase.Methods.GetFieldNames

Previous Next

Populates a string list with the names of fields in a table.

Syntax:

procedure GetFieldNames(const TableName: String;
                                   List: TStrings);

Description:

Call GetFieldNames to retrieve a list of fields in a table.

TableName

Names the table whose field names you want added to the list.

List

A TStrings descendant that receives the field names. Any existing strings are deleted from the list before GetFieldNames adds the names of all the fields in TableName.

For example, the following line fills a list box with the names of all fields in the table:

Database1.GetFieldNames('Employee', ListBox1.Items);