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:

Re: MySql and AdoDb experience

Post by l3whmg »

Hello everyone,
I understand your point of view on ODBC, which is a little more complicated (library, installing drivers) :geek: .
I really liked the "simplicity" :mrgreen: of the syntax of the instructions that I could use, especially when I had to refer to individual fields or set up a SQL string and so on.
I believe that the library hbmysql creates fewer problems (I think using socket connection for access :roll: ), but I did not make significant evidence: I'll try!
About date fields (but the same for other fields) the problem is: can the language/compiler use them? I am limited to dates in the standard format (like dd-mm-yyyy) appropriately managed by clipper; as mentioned by Roberto, I've used a version of WAMP (http://www.appservnetwork.com). I'll try XAMPP (http://www.apachefriends.org)

Thank (many thanks) you for your attention shown to my little job.

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 MySQL and hbmysql for one reason - record locking future built in MySQL.
But, in my opinion, it doesn't work.

I'll try to reach record locking effect with ODBC.
I'll write about my results.

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:I've tried MySQL and hbmysql for one reason - record locking future built in MySQL.
But, in my opinion, it doesn't work.

I'll try to reach record locking effect with ODBC.
I'll write about my results.

Marek
Please, read this thread:

http://www.webmaster-talk.com/the-datab ... cking.html

At the end there is a very interesting sample that could be useful for you.

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:I've tried MySQL and hbmysql for one reason - record locking future built in MySQL.
But, in my opinion, it doesn't work.

I'll try to reach record locking effect with ODBC.
I'll write about my results.

Marek
There is another interesting thread:

http://www.foxite.com/archives/lock-rec ... 045174.htm

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
l3whmg
Posts: 694
Joined: Mon Feb 23, 2009 8:46 pm
Location: Italy
Contact:

Re: MySql and AdoDb experience

Post by l3whmg »

Ciao Marek,
I hope to indicate a right way. I remember having found these instructions:
- You must properly configure MySql, because it has the automatism that may affect or alter the use of Lock and Unlock even at the row level.
- It is better to use InnoDB because (it seems) is the only way (like Clipper) to perform the row-level locking.
- Best to approach the SQL string.
- Successfully set a parameter, when accessing to the database, which responds to precise rules (if you've noticed, in my library was provided a numeric parameter).

All these informations I found browsing Internet and the site http://dev.mysql.com/ :roll:

I'm sorry, but my experiences on a row-level locking were unlucky :oops:

I hope to have you provided useful informations and not misleading.

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'll back to test MySQL when I find a little free time.
Thanks for suggestions.
Post Reply