HMGforum.com

Hi dragancesu,
I try connecting to a database on a linux server but i couldn't i think it's because you convert to lower case te name of the database and on linux the uppercase has to be respected could you make the changes on your code please for me to be able to check it.
Thankyou.

Hola dragancesu,
Intento conectar con una base de datos en un servidor del linux pero no pude pienso que es porque usted convierte a minúscula el nombre de la base de datos y en linux la mayúscula tiene que ser respetada usted podría hacer los cambios en su código por favor para poder probar el programa.
Gracias.

I'm glad someone reads and teach mysql

This is all done for Windows, but I believe someone else uses the linux and will help you

Can you write which code is your real problem

Every developer wants a quick result

This is one way to quickly load data from dbf to mysql database

Compile import_dbf and run

Choose dbf and be create the program impDbfName.prg

Compile impDbfName.prg and run

p.s. Mysqlfn.prg is a program with functions for connecting with mysql

Libmysql.dll is required to run the program, this or your version

Great Job Dragan ! Thanks, Serge

Here it was said about MySQL database, access through HeidiSQL, and finally data load

Did anyone try and help him? Are you satisfied with the instructions?

Hola, muy bueno el tutorial.
Estuve realizando las practias y funcionan.
Mi consulta es la siguiente: ¿Cómo hacer el bloqueo de registros en MySql? es decir cuando un usuario esta modificando un registro y otro quiere acceder a dicho registro, cómo indicarle que esta en uso?
Gracias
Claudio

Hi, very good tutorial.
I was doing the practices and they work.
My query is: How do I lock records in MySql? when a user is modifying a record and another wants to access such a record, how to indicate that it is in use?
Thank you
Claudio

In principle, it is not necessary to lock the tables, it works the database, when a COMMIT is made, the change is written

On the other hand, the question is what the other user sees, see the result of the last SELECT, if user thinks that the change has to be repeated by SELECT and that's all

When a base is used then the organization is different, someone enters the data, someone is watching the reports, as soon as the data is entered and saved, it will be visible to the new report

If you necessarily want to lock the database/table/records, you can begin a transaction as 'EXCLUSIVE'. In that way, others can not 'select' any table or run any query.

Some years ago I've tries record locking in mysql table. The same program worked ok on one computer, on the another record locking didn't work. The same version of mysql installed.
So I've left it.

I do not understand anything.
Regardless of the language or database type, a record must be blocked for modification. Otherwise, two users could modify it at the same time and the data of the last one would save the record.
And blocking the whole database to add a phone number, for example, seems excessive.