MySql and AdoDb experience
Moderator: Rathinagiri
MySql and AdoDb experience
Hello everyone.
I decided to share my little experience with MySQL and HMG.
I hope that the example included is helpful and clear.
There are (I found/know) some problems , such as:
- Special characters like à, è, etc. Yes, I have configured database with correct collating sequence , but (perhaps) the problem is the connection collating sequence that is UTF8; for this reason I’ve leaved database with UTF8 and use UTF8 function.
- Timestamp, Tiny, Datetime, etc.: conversion problem
- other
But, I think, is intuitive for newbe like me! I hope this experience it’s helpful.
Help, tips are appreciated and welcome
Regards
I decided to share my little experience with MySQL and HMG.
I hope that the example included is helpful and clear.
There are (I found/know) some problems , such as:
- Special characters like à, è, etc. Yes, I have configured database with correct collating sequence , but (perhaps) the problem is the connection collating sequence that is UTF8; for this reason I’ve leaved database with UTF8 and use UTF8 function.
- Timestamp, Tiny, Datetime, etc.: conversion problem
- other
But, I think, is intuitive for newbe like me! I hope this experience it’s helpful.
Help, tips are appreciated and welcome
Regards
- Attachments
-
- l3w_adodbmys.zip
- (8.07 KiB) Downloaded 685 times
Luigi from Italy
www.L3W.it
www.L3W.it
Re: MySql and AdoDb experience
Thanks a lot for sharing..............
Hope you will get feedback from Rathi, Sudip who have experimented MySQL & HMG combination.
Hope you will get feedback from Rathi, Sudip who have experimented MySQL & HMG combination.
Re: MySql and AdoDb experience
Hi Luigi!
I want to test your project, but you didn't attach one file: l3w_adodbmys.prg
Could you attach this file to the archive?
Marek
I want to test your project, but you didn't attach one file: l3w_adodbmys.prg
Could you attach this file to the archive?
Marek
Re: MySql and AdoDb experience
Hi.
I'm very, very sorry . I don't see my mistake.
Now I've included.
Bye
I'm very, very sorry . I don't see my mistake.
Now I've included.
Bye
- Attachments
-
- l3w_adodbmys.zip
- (12.62 KiB) Downloaded 662 times
Luigi from Italy
www.L3W.it
www.L3W.it
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: MySql and AdoDb experience
Hi Luigi,
thanks for your release
i'm going to see your program.
best regards,
Luis Vasquez
thanks for your release
i'm going to see your program.
best regards,
Luis Vasquez
Re: MySql and AdoDb experience
salve Marek, salve Luis,
vi ricordo che è un esperimento, una esperienza; non tutte le funzioni sono state verificate accuratamente. Inoltre, ricordate i problemi legati al tipo di dato. NON usatela in produzione!
Google translator
I remind you that it is an experiment, an experience; not all functions were checked thoroughly. Also, remember the problems associated with the type of data. Do not use it in production!
Best regards
vi ricordo che è un esperimento, una esperienza; non tutte le funzioni sono state verificate accuratamente. Inoltre, ricordate i problemi legati al tipo di dato. NON usatela in produzione!
Google translator
I remind you that it is an experiment, an experience; not all functions were checked thoroughly. Also, remember the problems associated with the type of data. Do not use it in production!
Best regards
Luigi from Italy
www.L3W.it
www.L3W.it
Re: MySql and AdoDb experience
I've tried it looking solution for retrieving date fields - but I found own...
Against it, thanks for sharing your work!
But, with HMG you can operate MySQL database without ODBC, which complicated (I thing) work.
Marek
Against it, thanks for sharing your work!
But, with HMG you can operate MySQL database without ODBC, which complicated (I thing) work.
Marek
- Roberto Lopez
- HMG Founder
- Posts: 4004
- Joined: Wed Jul 30, 2008 6:43 pm
Re: MySql and AdoDb experience
Yes, but it brings the libmysqldll.dll distribution licensing problems...mol wrote: But, with HMG you can operate MySQL database without ODBC, which complicated (I thing) work.
Regards,
Roberto.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- Roberto Lopez
- HMG Founder
- Posts: 4004
- Joined: Wed Jul 30, 2008 6:43 pm
Re: MySql and AdoDb experience
I have not enough time right now to work on it, but I still thinking that the best approach is to access MySql in the same way as an html client (web page) does, via HBTIP.mol wrote:You're right, Roberto
That way, you can use a LAMP (standard) server that can be accessed simultaneously with desktop (HMG) applications on Windows via HTML on any other devices bundled with a web browser.
The trick is that a PHP script returns the recordset as text that could be rendered as a local table to work with it (this was widely discussed here and very interesting code was uploaded).
Regards,
Roberto.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)