Jump to content
Sign in to follow this  
Stéphane Wierzbicki

Firedac GetFieldNames doesn't retrieve all fields list

Recommended Posts



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:



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 by Stéphane Wierzbicki

Share this post

Link to post

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 by Guest

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this