FiveTech Software tech support forums

... ArrCell(): Methods for direct manipulation of array data source cells.

Lock(), UnLock(): Methods for controlling data modification by locking/unlocking the browse.

Analogy: These are like the tools you use to repair or modify your car – wrenches, paintbrushes, etc. They allow you to ...

... hardware is optimally utilized, DBF programmers actually have all the possibilities to operate the database efficiently and stably through precise locking and integrity strategies. Therefore, the usual criticism of parallel access and data integrity is less relevant in this specific case.

This way ...

... very old programs.

XBrowse internally builds bOnPost edit codeblock suitable for the database used. XBrowse knows how to save changes, including locking and unlocking records.

Let us now test the same program without bOnPostEdit

This is the modified code.
#include "fivewin.ch"

REQUEST DBFCDX ...

It should be the most efficient locking scheme under Windows:

https://www.hamor.ro/distr_ext/Doc/xHb/ ... me.en.html

Tim,
Unfortunately, we have no alternatives available. It is very sad.

In my opinion some solutions there should be when Jimmy says

when DBF is used in Share Mode only Once, it will use SMB "Exlusive Locking" Mode
as soon when DBF was opened second Time it will switch into "Opportunistic Locking"

... lan


Let's not think about anything other than this clarifying example


when DBF is used in Share Mode only Once, it will use SMB "Exlusive Locking" Mode
as soon when DBF was opened second Time it will switch into "Opportunistic Locking"


Jimmy probably came close to the problem but in my ...

hi Marco,

this is the normal SMB behavior.

when DBF is used in Share Mode only Once, it will use SMB "Exlusive Locking" Mode
as soon when DBF was opened second Time it will switch into "Opportunistic Locking" Mode https://learn.microsoft.com/de-de/windows/win32/fileio/opportunistic-locks
it have to ...

... SQL DBMS are designed to handle multiple connections and simultaneous operations more efficiently than DBF, which can have issues with file locking.
2. Scalability
Handling large volumes of data: SQL databases can handle large volumes of data more effectively by distributing the load across ...

... to flush (write) its disk buffers to physical device (HARD
COMMIT). It's out of application control what OS (or FS)
do with such request.

The locking and buffer flushing in Clipper and Harbour RDDs
is safe and user cannot desynchronize data using different
instruction order, i.e. DBSKIP(0 ...

There is a detail in the ads that must be observed when locking a record.
In a situation where we use a register to follow a sequence of numbers automatically and in the attempt at the exact moment another user is executing the addition of the number (Example) the register must be refreshed.
In my ...

Driessen,

I think there is another way to handle your problem, but it is a bit complicated.

Instead of the program locking a record when a user opens it and only unlocking it when the record is saved, the record is only locked for a split second when the record saved. Thus, nobody can walk away ...

... alias) for this workarea */
#define DBI_GETSCOPE 34 /* The codeblock used in LOCATE */
#define DBI_LOCKOFFSET 35 /* The offset used for logical locking */
#define DBI_SHARED 36 /* Was the file opened shared? */
#define DBI_MEMOEXT 37 /* The memo file's file extension */
#define DBI_MEMOHANDLE 38 ...

Hi,

Why don't you use this function : WNetGetUser()

Good luck.
I guess probably because he's looking for someone connected to the server or locking a file.

You can use the following function to start working.

FUNCTION TstUser()LOCAL cDest := "procown.ps1"LOCAL   nHndlnHndl ...

... I want to add a record, I open the file, get the proper value ( there are fields for each file ), increment it by one, then save the new value. Locking applies. Again, it takes milliseconds to do this, and with hundreds of thousands of records written each year, my clients have NEVER encountered a ...

... I want to add a record, I open the file, get the proper value ( there are fields for each file ), increment it by one, then save the new value. Locking applies. Again, it takes milliseconds to do this, and with hundreds of thousands of records written each year, my clients have NEVER encountered a ...