FiveTech Software tech support forums

... use (set lShared to .f., it defaults to .t.). Method New( cAlias, cFile, cDriver, lShared, lReadOnly ) Class TData The reason you can't just do an flock() on a shared database is that other users could have it open and even be editing a record when you do the flock. By opening it in exclusive use, ...

Hello. Sorry for my English. Can I open a DBF Shared, and later do a FLock() to make a ZAP()?????????????????????????????????? I open a DBF in this way - I'm using TData from Mr. James Bott CLASS TSala from TXData   Method New()ENDCLASSMethod ...

... now it is enough to call RefreshCurrent() after editing. - Now, locking and unlocking actions of browse do not disturb any file or record locks ( flock() / dbrlock(nrec) ) already placed by the programmer. Also, now internal locking by xbrowse includes evaluation of bOnChange also. - Fix: Seekbar ...

... revisando el código las instrucciones de bloqueo de archivos para hacer los ingresos, modificaciones o eliminaciones, utilizaba la clausula FLOCK(), "bloqueo de archivo" , las reemplace por las RLOCK(),"bloqueo de registro", saque en todas partes la clausula COMMIT, (aquí ...

... revisando el código las instrucciones de bloqueo de archivos para hacer los ingresos, modificaciones o eliminaciones, utilizaba la clausula FLOCK(), "bloqueo de archivo" , las reemplace por las RLOCK(),"bloqueo de registro", saque en todas partes la clausula COMMIT, (aquí ...

HB_FUN_HB_CODEPAGE_HR646 @367 HB_FUN_HB_CODEPAGE_HR852 @368 HB_FUN_HB_CODEPAGE_HRISO @369 HB_FUN_HB_CODEPAGE_HRWIN @370 HB_FUN_HB_CODEPAGE_HU852 @371 HB_FUN_HB_CODEPAGE_HU852C @372 HB_FUN_HB_CODEPAGE_HUISO @373 HB_FUN_HB_CODEPAGE_HUWIN @374 HB_FUN_HB_CODEPAGE_IS850 @375 HB_FUN_HB_CODEPAGE_IS861 @376...

EXPORTS HB_FUN_AADD @1 HB_FUN_ABS @2 HB_FUN_ACCELERATO @3 HB_FUN_ACCELERATOR @4 HB_FUN_ACHOICE @5 HB_FUN_ACLONE @6 HB_FUN_ACOPY @7 HB_FUN_ADEL @8 HB_FUN_ADIR @9 HB_FUN_AEVAL @10 HB_FUN_AFIELDS @11 HB_FUN_AFILL @12 HB_FUN_AINS @13 HB_FUN_ALERT @14 HB_FUN_ALIAS @15 HB_FUN_ALLTRIM @16 HB_FUN_ALTD @17 H...

I am getting the impression that I offended you no problem at all My before code shows how to file system handle can lock or only mark as used... all depend... the key is how use it. Other key is open files of named system 'in use mark' in fopen shared mode. This permit to other users collect info ...

File locks are issued all the time behind the scenes. Every skip on a shared dbf with an index locks the index file until after skip is complete. This is to ensure that the index tree has not changed until after the next record is resolved. Having the locks cached is not the best idea when each user...

... meant locked. They are very similar. A locked file blocks write access. Maybe this is a language translation thing. From the Clipper help file: FLOCK() is a database function used in network environments to lock an open and shared database file, preventing other users from updating the file ...

James Bott wrote:The problem is that as long as the computer is frozen, no one else on the network can access the locked file(s).

I'm not

what is a blocked file ? Is it a file opened in shared mode ?

Eduardo, Did you mean file locks or record locks? Either way, I use database objects. I wrote a subclass to TDatabase which adds many enhancements. I added some enhancements for record locking including automatic retries if a record is already locked. Personally, I aways use optimistic locking so a ...

Hello,

And how do You Manage record locks?.

Thank You

The problem is that as long as the computer is frozen, no one else on the network can access the locked file(s). I'm not saying this is a big issue, but I have had clients that just left it frozen until I came in to fix it. This left everyone else without access to the file. It only happens rarely, ...

Reinaldo, gracias por tu respuesta

Uso Tablas ADT

Quiero entender que si utilizo AdsLocking( .T. ) ADS bloquea los registros ??
(a la hora de escribir en la tabla)

si utilizo AdsLocking( .F. ) yo tengo que bloquear los registros ??
(en todo el sistema yo utilizo RLock, FLock y DbUnLock)