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 » Fri Sep 04, 2009 8:27 pm

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 212 times
Luigi from Italy
www.L3W.it

User avatar
swapan
Posts: 242
Joined: Mon Mar 16, 2009 4:23 am
Location: Kolkata, India
Contact:

Post by swapan » Sat Sep 05, 2009 5:23 am

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: 2878
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 136 times
Been thanked: 69 times
Contact:

Post by mol » Fri Oct 02, 2009 12:54 pm

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:

Post by l3whmg » Fri Oct 02, 2009 7:11 pm

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 172 times
Luigi from Italy
www.L3W.it

User avatar
luisvasquezcl
Posts: 1039
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Has thanked: 12 times
Been thanked: 14 times
Contact:

Post by luisvasquezcl » Fri Oct 02, 2009 11:40 pm

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:

Post by l3whmg » Mon Oct 05, 2009 7:35 pm

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: 2878
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 136 times
Been thanked: 69 times
Contact:

Post by mol » Tue Oct 06, 2009 5:27 am

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: 3902
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 13 times
Been thanked: 137 times

Post by Roberto Lopez » Tue Oct 06, 2009 1:31 pm

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
mol
Posts: 2878
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 136 times
Been thanked: 69 times
Contact:

Post by mol » Tue Oct 06, 2009 3:24 pm

You're right, Roberto :)

User avatar
Roberto Lopez
HMG Founder
Posts: 3902
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 13 times
Been thanked: 137 times

Post by Roberto Lopez » Tue Oct 06, 2009 9:54 pm

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