Firedac GetFieldNames doesn't retrieve all fields list

[Stéphane Wierzbicki 45]

Hi,

 

I am recovering MsSQL tables fields with the help of the GetFieldNames method, however some list fields are incomplete. 

 

For example, I do have a table name with a string field called "USER' (reserved word, i know but I cannot to anything against this), calling GetFieldNames retrieve everything except the 'USER' field. 

 

I'm calling GetFieldNames this way:

FDConnection.GetFieldNames('','',Tablename,'',Fieldlist)

 

Where Tablename is a string containing table name and Fieldlist is a TStringlist.

 

Is there anything I can do?

 

PS: I'm using Delphi 11

 

Edited February 27, 2022 by Stéphane Wierzbicki

[Guest]

on StackOverFlow have this:

MSSQL DB:  select column_name, data_type, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'tablename';

https://stackoverflow.com/questions/21024995/how-to-use-a-firedac-tfdconnection-to-iterate-through-tables-fields-and-field-d

[Stéphane Wierzbicki 45]

@joaodanet2018 thanks for the workaround (using TFDMetaInfoQuery will also do the trick) but why oh why does GetFieldNames not work ?

[Guest]

maybe something retaled to schema/internal system use to not-show  ... i dont use MSSQL.

better never use internal names for avoid conflict or others

Edited February 27, 2022 by Guest