Page 1 of 2

MySql and AdoDb experience

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

Re: MySql and AdoDb experience

Posted: Sat Sep 05, 2009 5:23 am
by swapan
Thanks a lot for sharing..............

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

Re: MySql and AdoDb experience

Posted: Fri Oct 02, 2009 12:54 pm
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

Re: MySql and AdoDb experience

Posted: Fri Oct 02, 2009 7:11 pm
by l3whmg
Hi.
I'm very, very sorry :oops: . I don't see my mistake.
Now I've included.
Bye

Re: MySql and AdoDb experience

Posted: Fri Oct 02, 2009 11:40 pm
by luisvasquezcl
Hi Luigi,
thanks for your release
i'm going to see your program.
best regards,
Luis Vasquez

Re: MySql and AdoDb experience

Posted: Mon Oct 05, 2009 7:35 pm
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

Re: MySql and AdoDb experience

Posted: Tue Oct 06, 2009 5:27 am
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

Re: MySql and AdoDb experience

Posted: Tue Oct 06, 2009 1:31 pm
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.

Re: MySql and AdoDb experience

Posted: Tue Oct 06, 2009 3:24 pm
by mol
You're right, Roberto :)

Re: MySql and AdoDb experience

Posted: Tue Oct 06, 2009 9:54 pm
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.