MySql revisited
Moderator: Rathinagiri
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
My research with HMG and MySQL
For test I use http://www.uniformserver.com/ZeroXI_doc ... guide.html
It's web server with apache/php/mysql but I run only MySQL, ideal for test and develop
For MySQL administration I use HeidiSQL.com , small mysql manager portable, (delphi source)
For program develop I create my system, named MyHMG for create simple form, master/detail form and report
All need is in attachment (and libmysql.dll)
For test I use http://www.uniformserver.com/ZeroXI_doc ... guide.html
It's web server with apache/php/mysql but I run only MySQL, ideal for test and develop
For MySQL administration I use HeidiSQL.com , small mysql manager portable, (delphi source)
For program develop I create my system, named MyHMG for create simple form, master/detail form and report
All need is in attachment (and libmysql.dll)
- Attachments
-
- myhmg.zip
- (1.64 MiB) Downloaded 454 times
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
This is demo for myhmg with country table, two forms, simple and grid, and report
Forms have all functions for insert, edit, delete, query
In zip is programs and table backup in sql format
When work with database (like mysql) I create tables and others database object (index, view) by database manager, not from program
Connected defined in config.ini - good for test, not good for production
Note: key field is named ID (auto-increment), can be dificulty but program must be (litle) changed
Forms have all functions for insert, edit, delete, query
In zip is programs and table backup in sql format
When work with database (like mysql) I create tables and others database object (index, view) by database manager, not from program
Connected defined in config.ini - good for test, not good for production
Note: key field is named ID (auto-increment), can be dificulty but program must be (litle) changed
- Attachments
-
- demo.zip
- (27.2 KiB) Downloaded 432 times
Re: MySql revisited
Sorry "libmysql.dll" and "xampp" what version are you using? thank you
Re: MySql revisited
Sir may know how to use libmysql and mysql version ?, because I try not yet thank you
dragancesu wrote: ↑Sun Feb 12, 2017 12:54 pm Have nice examples on \HMGxxx \ Samples \ hfcl \ mysql
Solution with TMySQL is good, you need just libmysql.dl from mysql server installation, and that's all
Rathi with HMGMySQL Bridge made just library to establish a connection, accept (SELECT) and later return (UPDATE)
the second solution is that these functions are placed in the program and added to the project (so do I)
It will be easier if you write down what you've been able to do
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
I am on holiday, when return home I will prepare small manual for work with MySQL for beginers
Re: MySql revisited
Sin Duda Alguna,
Este Trabajo Es De Alta Contribucion En Este Foro.
Muchas Gracias.
Este Trabajo Es De Alta Contribucion En Este Foro.
Muchas Gracias.
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
As I promised, I prepared a short manual for working with mysql
- Attachments
-
- mysql part 1.zip
- (316.07 KiB) Downloaded 477 times