firemonkey sql querry programatically

[geanni]

Hi,
When creating a query programatically like this:

TMyQuery* myQuery = new TMyQuery(this);
myQuery->Connection = MyConnection1;

UnicodeString str;
str = "SELECT id, first_name, city, country, visits, phone, VIP, room_nr, email FROM customers ";
myQuery->SQL->Clear();
myQuery->SQL->Add(str);
myQuery->Execute();
TFields* fields =myQuery->Fields;
int cnt = fields->Count;

The maximum number of fields is always 6. We need more then 6 fields. Can you reproduce the bug and give us a solution?
Thanks.

[AndreyZ]

Hello,

This is a restriction of the MyDAC Trial version only. The maximum number of columns in a dataset is limited to six fields for Win x64, OSX, and Linux platforms. You will not have this problem with a licensed MyDAC version.

[geanni]

Hi,
This was the problem.

Thank you,
Geanni

[AndreyZ]

Feel free to contact us if you have any further questions about MyDAC.