MySql and AdoDb experience

[l3whmg]

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

[swapan]

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

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

[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

[l3whmg]

Hi.
I'm very, very sorry . I don't see my mistake.
Now I've included.
Bye

[luisvasquezcl]

Hi Luigi,
thanks for your release
i'm going to see your program.
best regards,
Luis Vasquez

[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

[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

[Roberto Lopez]

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.

[mol]

You're right, Roberto

[Roberto Lopez]

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.