MySql revisited

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 453
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 64 times

Re: MySql revisited

Post by dragancesu » Sun Feb 26, 2017 9:46 pm

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 81 times

User avatar
dragancesu
Posts: 453
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 64 times

Post by dragancesu » Mon Feb 27, 2017 8:07 am

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 71 times

bels79
Posts: 36
Joined: Fri Sep 09, 2011 8:01 am
Has thanked: 1 time
Been thanked: 1 time

Post by bels79 » Thu Jun 22, 2017 9:23 am

Sorry "libmysql.dll" and "xampp" what version are you using? thank you

bels79
Posts: 36
Joined: Fri Sep 09, 2011 8:01 am
Has thanked: 1 time
Been thanked: 1 time

Post by bels79 » Fri Jun 23, 2017 2:17 am

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: 453
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 64 times

Post by dragancesu » Fri Jun 23, 2017 9:54 am

I am on holiday, when return home I will prepare small manual for work with MySQL for beginers

ASESORMIX
Posts: 59
Joined: Thu Oct 25, 2012 8:08 pm
Location: Bqto, Venezuela
Been thanked: 4 times

Post by ASESORMIX » Sat Jun 24, 2017 9:55 pm

Sin Duda Alguna,
Este Trabajo Es De Alta Contribucion En Este Foro.
Muchas Gracias.

User avatar
dragancesu
Posts: 453
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 64 times

Post by dragancesu » Fri Jul 21, 2017 7:55 am

As I promised, I prepared a short manual for working with mysql
Attachments
mysql part 1.zip
(316.07 KiB) Downloaded 94 times

User avatar
bpd2000
Posts: 947
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 118 times
Been thanked: 42 times

Post by bpd2000 » Fri Jul 21, 2017 8:32 am

Thank you for sharing
BPD
Convert Dream into Reality through HMG


User avatar
quartz565
Posts: 442
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Has thanked: 103 times
Been thanked: 11 times
Contact:

Post by quartz565 » Fri Jul 21, 2017 5:45 pm

Thank you Dragan !
Best Regards,
Nikos.

os: Windows Server 2012 - 64
hw: HP Server E5606, 2.13GHz, 8.00 GB - Intel Xeon CPU

Post Reply