MySql revisited

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

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)
Attachments
myhmg.zip
(1.64 MiB) Downloaded 444 times
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

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
Attachments
demo.zip
(27.2 KiB) Downloaded 416 times
bels79
Posts: 37
Joined: Fri Sep 09, 2011 8:01 am
DBs Used: DBF, MySQL

Re: MySql revisited

Post by bels79 »

Sorry "libmysql.dll" and "xampp" what version are you using? thank you
bels79
Posts: 37
Joined: Fri Sep 09, 2011 8:01 am
DBs Used: DBF, MySQL

Re: MySql revisited

Post by bels79 »

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
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

I am on holiday, when return home I will prepare small manual for work with MySQL for beginers
ASESORMIX
Posts: 189
Joined: Thu Oct 25, 2012 8:08 pm
Location: Bqto, Venezuela

Re: MySql revisited

Post by ASESORMIX »

Sin Duda Alguna,
Este Trabajo Es De Alta Contribucion En Este Foro.
Muchas Gracias.
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

As I promised, I prepared a short manual for working with mysql
Attachments
mysql part 1.zip
(316.07 KiB) Downloaded 464 times
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: MySql revisited

Post by bpd2000 »

Thank you for sharing
BPD
Convert Dream into Reality through HMG
User avatar
quartz565
Posts: 667
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Contact:

Re: MySql revisited

Post by quartz565 »

Thank you Dragan !
Best Regards,
Nikos.

os: Windows Server 2019 - 64
Post Reply