MySql revisited

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

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

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

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

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

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

Post by bels79 »

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

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

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

Post by dragancesu »

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

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

Post by ASESORMIX »

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

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

Post by dragancesu »

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

User avatar
bpd2000
Posts: 1160
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 248 times
Been thanked: 142 times

Post by bpd2000 »

Thank you for sharing
BPD
Convert Dream into Reality through HMG


User avatar
quartz565
Posts: 598
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Has thanked: 206 times
Been thanked: 23 times
Contact:

Post by quartz565 »

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