Good evening people,
I have problem retrieving data from SQL database in C++ Builder 6.
I have connected, made queries, but I don't know what function get data.
I know in PHP there is mysql_fetch_array and later in code I can use just array which indexes are data from each column in database table.
How can I do that in C++ builder?
1 2 3 4
DataModule2->Query2->SQL->Clear();
DataModule2->Query2->SQL->Add("SELECT * FROM 'lietotaju_info.db' WHERE User_name = '"+lbl_name->Caption+"'");
lbl_money->Caption = ????
DataModule2->Query2->ExecSQL();