MySql and AdoDb experience

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
l3whmg
Posts: 694
Joined: Mon Feb 23, 2009 8:46 pm
Location: Italy
Contact:

MySql and AdoDb experience

Post by l3whmg »

Hello everyone.
I decided to share :o my little experience with MySQL and HMG.
I hope that the example included is helpful and clear.
There are (I found/know) some problems :oops: , 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 :D

Regards
Attachments
l3w_adodbmys.zip
(8.07 KiB) Downloaded 616 times
Luigi from Italy
www.L3W.it
User avatar
swapan
Posts: 242
Joined: Mon Mar 16, 2009 4:23 am
Location: Kolkata, India
Contact:

Re: MySql and AdoDb experience

Post by swapan »

Thanks a lot for sharing..............

Hope you will get feedback from Rathi, Sudip who have experimented MySQL & HMG combination.
Thanks & Regards,
Swapan Das

http://www.swapandas.com/
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: MySql and AdoDb experience

Post by mol »

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
User avatar
l3whmg
Posts: 694
Joined: Mon Feb 23, 2009 8:46 pm
Location: Italy
Contact:

Re: MySql and AdoDb experience

Post by l3whmg »

Hi.
I'm very, very sorry :oops: . I don't see my mistake.
Now I've included.
Bye
Attachments
l3w_adodbmys.zip
(12.62 KiB) Downloaded 578 times
Luigi from Italy
www.L3W.it
User avatar
luisvasquezcl
Posts: 1258
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Contact:

Re: MySql and AdoDb experience

Post by luisvasquezcl »

Hi Luigi,
thanks for your release
i'm going to see your program.
best regards,
Luis Vasquez
User avatar
l3whmg
Posts: 694
Joined: Mon Feb 23, 2009 8:46 pm
Location: Italy
Contact:

Re: MySql and AdoDb experience

Post by l3whmg »

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
Luigi from Italy
www.L3W.it
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: MySql and AdoDb experience

Post by mol »

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
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: MySql and AdoDb experience

Post by Roberto Lopez »

mol wrote: But, with HMG you can operate MySQL database without ODBC, which complicated (I thing) work.
Yes, but it brings the libmysqldll.dll distribution licensing problems...

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: MySql and AdoDb experience

Post by Roberto Lopez »

mol wrote:You're right, Roberto :)
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.

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)
Post Reply