Hello everyone,
I understand your point of view on ODBC, which is a little more complicated (library, installing drivers) .
I really liked the "simplicity" 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 ), 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.
MySql and AdoDb experience
Moderator: Rathinagiri
Re: MySql and AdoDb experience
Luigi from Italy
www.L3W.it
www.L3W.it
Re: MySql and AdoDb experience
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
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
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
Re: MySql and AdoDb experience
Please, read this thread: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
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)
Roberto
(Veritas Filia Temporis)
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
Re: MySql and AdoDb experience
There is another interesting thread: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
http://www.foxite.com/archives/lock-rec ... 045174.htm
Regards,
Roberto.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
Re: MySql and AdoDb experience
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/
I'm sorry, but my experiences on a row-level locking were unlucky
I hope to have you provided useful informations and not misleading.
Best regards
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/
I'm sorry, but my experiences on a row-level locking were unlucky
I hope to have you provided useful informations and not misleading.
Best regards
Luigi from Italy
www.L3W.it
www.L3W.it
Re: MySql and AdoDb experience
I'll back to test MySQL when I find a little free time.
Thanks for suggestions.
Thanks for suggestions.