FiveTech Software tech support forums

... different instruction order, i.e. DBSKIP(0)/UNLOCK/COMMIT,... The only problems which can appear are in OS or FS, i.e. the infamous opportunistic locks is MSDN networks which may completely break applications using concurrently the same files and synced by file range and file access locks. This ...

... Anyway, you mixed the R lock flavor and the normal lock flavor. With DBRLOCK() you must use DBRUNLOCK(). And furthermore, APPEND BLANK operation locks the newly appended record so there is no need of another lock.

... a possibility that this record can unlocked by another user? Thank you. Not possible. In ADS, Administrator can kill a user. That frees all his locks. Well behaved programs never lock a record and wait for a user action. Lock only when all data is ready, then lock and write all data and unlock ...

This is xHarbour style of extended codeblock <|oLbx|    local oRect := oDlg:  GetCliRect  (  )       oBar:  nWidth := oRect:  nWidth       oLbx:  nWidth := oRect:  nWidth -   210    RETURN   NIL >  Harbour style {|oLbx|    local oRect := oDlg:  GetCliRect  (  )       oBar:...

... table. If you want to actually remove them, you can pack the table with PACK. Rows that were just edited are returned to their saved values. All locks made during a transaction are maintained until the transaction is completed. This ensures that no one else can make any changes until the transaction ...

... I get a MsgInfo() saying TBAR, and then one saying TXBROWSE. These tend to repeat on any dialogs using the bar control and the browse control. It locks up the program. The exact same code compiled with the 32 bit FWH is working. However, I am trying to actually focus on full 64 bit development. ...

hi Marc, I also have no idea about the SMB problem (no idea what SMB is (look into it) read here about Opportunistic locks (oplocks) https://docs.microsoft.com/en-US/windows/win32/fileio/opportunistic-locks this Paper is about : "What's New in SMB" Applies To: ...

... and pushes all records down by one record. Optionally writes non empty values of aValues to the inserted record. When the function returns all locks are removed. * Cursors: Cursor can be defined from a file (cur/ico) also. eg DEFINE CURSOR oCur FILE "mycur.cur" During runtime, cursor ...

... #define DBI_FOUND 29 /* Same as found() */ #define DBI_FCOUNT 30 /* How many fields in a record? */ #define DBI_LOCKCOUNT 31 /* Number of record locks */ #define DBI_VALIDBUFFER 32 /* Is the record buffer valid? */ #define DBI_ALIAS 33 /* Name (alias) for this workarea */ #define DBI_GETSCOPE ...

... shell window from appearing, the script must be run through Wscript and cmd.exe . Of course, I made a flag DBF, where each launching application locks its own line. But it seemed to me that by viewing all processes through WMI, you can find out the name of the user on whose behalf a particular ...

... NOT handle the memo fields. In fact, when going into a memo field on an individual record, it just gives the hour glass and spinning circle and locks in that position. Also the Imp/Exp command does nothing but show a popup dialog. These tests were only able to be performed when I commented out ...

... Mostly tables are opened with optimistic locking and there is no need to locking. If we open a table with pessimistic locking, we can use record locks. We advise you to unlearn DBF programming habits and record locking is not desirable or practiced normally. Anyway, it is upto you.

... } ) STATES->( FW_DBLOOKUP( 10, 0, "FIELD->NAME" ) ) // at recno 10 Original recno() and order are restored and any previous locks are left intact before returning. Reurn value NIL indicates failure source: \fwh\function\dbffuns2.prg ITEMS->( FW_DBLOOKUP( 101, "ITEMCODE", ...

Hi, File locks are not stored anywhere. They are kept in memory by the filesystem in the server OS. The dbf headers are always of the same size, they cannot change size because that is not easy to handle among several users. In ...

nageswaragunupudi wrote:

Thank you Carlos but no need to block and unblock the field like dbf table in lan enviroment?

SELECT ... FOR UPDATE
locks the record.

Thank you Nages in this case I need to treat the select return before save?