Devart Forums

Hello,

I am building a DLL (in Borland C++ Builder 6) witch is going to act as a layer between my software and a MySQL server.

I have two components: MyConnection and MyQuery.

this is what i am doing ( in short version):
MyQuery->SQL->Text = "SELECT * FROM "+ cmbTables->Text;
MyQuery->Execute();

the query is running and working because the MyQuery->RecordCount represents the exact number of rows.... but where can i get the returned values....

ok i found by help of the topic obove..... thank you

MyQuery->FieldValues[FieldName]

after executing the query by MyQuery->Execute();

To get returned values you can use Fields property. For example:

Label1->Caption = MyQuery1->Fields->Fields[2]->AsString;

For more information see description of TDataSet.Fields in C++Builder Help.

hmm thank you. I will try