FiveTech Software tech support forums

... Set new codsep aRow[8] := 0, // Reset record number or assign a new unique ID aAdd( oBrw:aArrayData, aRow ) // Add to the xBrowse array NEXT, oBrw:Unlock( .t. ), aCopy := NIL, // Reset aCopy oBrw:RefreshCurrent(), oBrw:SetFocus() ) ``` ### Generate Unique Identifiers For generating new unique IDs ...

... WHEN acopy!=NIL ACTION ( ; oBrw:Lock(), ; aCopy[ 1 ] := codsep ,; aCopy[ 8 ] := 0 ,; //recno aadd( oBrw:aArrayData, aCopy ),; oBrw:Unlock( .t. ), ; acopy:=NIL ,; oBrw:RefreshCurrent(), oBrw:SetFocus() ) ENDMENU but when I modify it the nRecord:= oBrowse:nArrayAt is the same

... https://www.home-assistant.io/integrations/openai_conversation/ The I can say 'Ok Google (HAL), please unlock the front door' and Google (HAL) answers...

... 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,... The only problems which can appear are in OS or FS, i.e. the infamous opportunistic locks is MSDN networks which may completely break ...

Dear Enrico, dear Mr. RAo, What about CLOSE. Many users use UNLOCK COMMIT CLOSE in their code. I think CLOSE is enough. But we also need built-in functions that can detect the actual data status. And this status is the cache status. Like the EXPLORER Perhaps ...

nageswaragunupudi wrote:So, let is be clear on this:
1. COMMIT is safe and ensures all data is physically written the disk. But not necessary to make the changes visible to other users.
2. UNLOCK is all that is enough to make the changes visible to users across the network.

Hope Mr. Enrico agrees on this.

Yes, I agree.

... on this: 1. COMMIT is safe and ensures all data is physically written the disk. But not necessary to make the changes visible to other users. 2. UNLOCK is all that is enough to make the changes visible to users across the network. Hope Mr. Enrico agrees on this. But commit is costly in terms ...

... the test program and get the right time and values. FOR I := 1 to 5000 APPEND BLANK REPLACE FIELD ->test WITH "TEST"+ str(i) + time() UNLOCK if I = 5000 ? FILEDATE( cDbf ), FILETIME( cDbf ) waitrun( 'powershell_ise.exe -file ".\ps_datumzeit.ps1"' ) endif NEXT # Definieren ...

... an experienced programmer like me to talk about it. But I see there are many opinions here. I can only confirm what Mr. Rao says. If you insert UNLOCK into Enrico's code, then the replace is carried out. I conduct my test as follows. I open the database with EmagDbu238 while the MsgInfo is displayed. ...

... the contents of the buffer are written to the disk buffers of the OS, other client PC buffers can not be refreshed. So we are clear that simple Unlock is flushing data and index buffers to the disk buffers of the Windows OS. Ultimately any RDD finally writes the data to the disk using fwrite ...

... : " + cValToChar( OrdKeyNo( "CITY" ) ) ;      SIZE 200,30 PIXEL OF oDlg UPDATE   @ 140, 20 BUTTON "Unlock" SIZE 140,30 PIXEL OF oDlg ;      ACTION ( DBRUNLOCK(), oDlg:Update(), oGet:SetFocus() )   @ 140,280 BUTTON ...

... I was trying to submit to our learned colleagues. COMMIT or NO COMMIT SET HARDCOMMIT ON OR OFF Simply changing the data and if shared executing UNLOCK is all that is enough to ensure visibility of data as well as indexes to all other users on the network immediately So, please keep aside the ...

Hi,

nageswaragunupudi wrote:After changing the value of a field, execution of UNLOCK is enough to make the change visible to all other users.

If _SET_HARDCOMMIT == .T. it's ok. If _SET_HARDCOMMIT == .F. then you need commit.

set( _SET_HARDCOMMIT, .F. ) Yes. The default is SET HARDCOMMIT ON After changing the value of a field, execution of UNLOCK is enough to make the change visible to all other users. Documentation: SET HARDCOMMIT ON | off | (<lOnOff>)ArgumentsON | off | (<lOnOff>) ...

... you must issue a COMMIT after all database update commands (e.g., APPEND, REPLACE). To insure data integrity, COMMIT should be issued before an UNLOCK operation. Refer to the “Network Programming” chapter for more information on update visibility. " Regards, saludos.