Devart Forums

Hi, all.
This is not specific question about MySQL, but....

1. Table have 2 fields: 'NAME' and 'DATE';
2. TMyQuery, SELECT * FROM ;
3. If property Fields is empty before query, Fields.Count = 2, ok;
4. If I add one TField to Fields (via Fields editor or runtime code) , Fields.Count = 1;

Questin: If I do item 4, how I can access to field 'DATE' via same TMyQuery?
FindField('DATE) = nil

If you create fields before opening dataset you should add all fields to which you need to have access. You can do it using the "Add all fields" pop-up menu of Fields Editor.