Esmu programmists-iesācējs, bet man sanāca(Turbo c++ & MySQL 5):
1. Velkam dbxopenmysql5_dll.zip un dbxopenmysql5_source.zip no https://www.justsoftwaresolutions.co.uk/delphi/dbexpress_and_mysql_5.html
2. Iekopējam dbxopenmysql50.dll c:windowssystem32 no dbxopenmysql5_dll.zip
3. Pievienojam c:Program FilesBorlandBDS4.0dbExpress dbxconnections.ini un dbxdrivers.ini informāciju no dbxopenmysql5_source.zip dbxconnections.ini un dbxdrivers.ini failiem
4. Atveram jaunu VCL projektu
5. Uzliekam uz formas TSQLConnection komponentu
6. TSQLConnection popupmenu->Edit Connection Properties
7. Connection Name=OpenMySQL50; HostName=localhost; Database=DB_name; User_Name=username; Password=password
8. TSQLConnection LoginPrompt=false
9. TSQLConnection popupmenu->Edit Connection Properties
10. √ (Test Connection) = “Successfully Connected” jābūt!
11. Uzliekam uz formas TSQLDataSet komponentu
12. TSQLDataSet SQLConnection=SQLConnection1
13. TSQLDataSet CommandType=ctQuery & CommandText=select * from DB_Table_Name
14. TSQLDataSet Active=true
15. Uzliekam uz formas TDataSetProvider komponentu
16. TdataSetProvider DataSet=SQLDataSet1
17. Uzliekam uz formas TClientDataSet komponentu
18. TClientDataSet ProviderName=DataSetProvider1
19. Uzliekam uz formas TDataSource komponentu
20. TDataSource DataSet=ClientDataSet1
21. Uzliekam uz formas TDBGrid komponentu
22. TDBGrid DataSource=DataSource1
23. TClientDataSet Active=true
24. void __fastcall TForm1::FormClose(TObject *Sender, TCloseAction &Action){if (ClientDataSet1->ChangeCount) ClientDataSet1->ApplyUpdates(0);} Ja vajag atcelt izmaiņas, tad ClientDataSet1->UndoLastChange(true);
https://www.roseindia.net/mysql/mysql5/mysql-create-and-delete-database.shtml
https://www.ibase.ru/devinfo/dbexpress.htm
https://www.devx.com/ibm/Article/11180/0/page/2
https://www.roseindia.net/mysql/mysql_backup_restore.shtml
P.S. Turbo C++ un Borland C++ Builder 6 nestrādā ar MySQL 5, tikai ar 4.1.x. Tāpēc ir jāvelk šie 2 zip faili.
Ceru, ka kādam šis noderēs…
.
