Data.SqlExpr.TSQLConnection.GetFieldNames
Delphi
procedure GetFieldNames(const TableName: string; List: TStrings); overload;
procedure GetFieldNames(const TableName: string; SchemaName: string; List: TStrings); overload;
C++
void __fastcall GetFieldNames(const System::UnicodeString TableName, System::Classes::TStrings* List)/* overload */;
void __fastcall GetFieldNames(const System::UnicodeString TableName, System::UnicodeString SchemaName, System::Classes::TStrings* List)/* overload */;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLConnection |
Description
Populates a string list with the names of fields in a table.
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 is 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 Employee table:
SQLConnection1.GetFieldNames('Employee', ListBox1.Items);
SQLConnection1->GetFieldNames("Employee", ListBox1->Items);