FiveTech Software tech support forums

... 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)/UNLOCK/COMMIT,... ...

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 ...

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 ...

... (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 ...

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 ...

... 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 ...

... "Share" a "File-Based" System using SMB SMB will "slow down" when 2nd User open same DBF -> "Opportunistic Locking" so i ask for at least 2 x PC and "Server" to simulate Access Time. I just opened five copies of my test browse program, all ...

... "Share" a "File-Based" System using SMB SMB will "slow down" when 2nd User open same DBF -> "Opportunistic Locking" so i ask for at least 2 x PC and "Server" to simulate Access Time. that is the Benefit of a Client / Server System where you ...

Dear Otto,

DBFs accesses on the web are managed by Harbour (and mod_harbour) the same way as on a LAN (shared access and record locking, unlocking)

So we have the same limitations that we have on a desktop EXE working on a LAN regarding the use of DBFs: almost none

... 2) How to run an Rlock or Flock to prevent two users from working on the same record or groups of records. We can open a table with optimistic locking or pessimistic locking. Mostly tables are opened with optimistic locking and there is no need to locking. If we open a table with pessimistic ...

... access problem from the Internet if the local EXE is open. I change that quickly in the program. But it is important that you see that the record locking and the file locking are working properly. The edit function has not yet been programmed in the EXE, so we are changing the data with the dBase ...

MS Access and MS Sql Server can use opportunistic locking .. Our Friend Rao has developed ADO Sql Wrappers that simplify the code below ... oRsEmp := TOleAuto():New( "ADODB.Recordset" )oRsEmp:CursorType     := 1 ...

... * FWMariaRowSet: New sample fwh\samples\marialok.prg for locking records while editing. http://forums.fivetechsupport.com/viewtopic.php?f=3&t=37928 * FWMariaRowSet METHOD EditBaseRecord( cFieldList, lNew, ...

... If you do not want to make the changes during edit but after closing the window, then open the reocordset with "adLockBatchOptimistic" locking and towards the end save all the changes by calling oRs:UpdateBatch() before calling oRs:Close() Note: We advise you use the default mode (i.e., ...