Search found 214 matches: unlock

Return to advanced search

Re: cloud or not cloud

... Please note that we did nothing except send the DBF table to the AI with a request for statistical analysis, and now we have the program. I didn't program a single line of the whole program manually! By the way, this PHP4DBF library largely uses FIVEWIN/HARBOUR syntax. The next prompt is now the...
by Otto
Fri Nov 15, 2024 9:50 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: cloud or not cloud
Replies: 34
Views: 1034

Re: Problem with lock record (dbf/cdx)

To All In this crazy world of data hacks and database injection ... I ( myself ) prefer to lock a record with code ... update a value and then unlock .. Database injection is easy to infiltrate any table if you have an auto-increment field .... Just something to think about. Rick Lipkin Very ...
by wartiaga
Sun Jun 16, 2024 1:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with lock record (dbf/cdx)
Replies: 9
Views: 720

Re: Problem with lock record (dbf/cdx)

To All

In this crazy world of data hacks and database injection ... I ( myself ) prefer to lock a record with code ... update a value and then unlock .. Database injection is easy to infiltrate any table if you have an auto-increment field .... Just something to think about.

Rick Lipkin
by Rick Lipkin
Sat Jun 15, 2024 6:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with lock record (dbf/cdx)
Replies: 9
Views: 720

Re: Ayuda con DLL

... :=TIME() oDbf:TURNO :=0 oDbf:PICO :=Q oDbf:PRODUC:=0 oDbf:PRECIO:=0 oDbf:AFOINI:=0 oDbf:AFOFIN:=0 oDbf:VTAVOL:=0 oDbf:VTAIMP:=0 oDbf:Save() oDbf:Unlock() NEXT ENDIF DBCLOSEALL() USE CONFICEM NEW DATABASE oDbf oDbf:bEoF=nil oDbf:bBoF=nil oDbf:GoTop() IPCem :=ALLTRIM(oDbf:IPCEM44) ModCem:=ALLTRIM(oDbf:MODOCEM) ...
by Jorge Jaurena
Tue Jun 04, 2024 2:18 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Ayuda con DLL
Replies: 8
Views: 567

Re: copy a row of xbrowse

... 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 ...
by Otto
Tue Dec 05, 2023 3:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: copy a row of xbrowse
Replies: 36
Views: 7666

Re: copy a row of xbrowse

... 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
by Silvio.Falconi
Tue Dec 05, 2023 1:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: copy a row of xbrowse
Replies: 36
Views: 7666

Re: Learn SQL with ChatGPT or when can ChatGPT really help

... https://www.home-assistant.io/integrations/openai_conversation/ The I can say 'Ok Google (HAL), please unlock the front door' and Google (HAL) answers...
by frose
Sat Nov 18, 2023 5:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Learn SQL with ChatGPT or when can ChatGPT really help
Replies: 9
Views: 996

Re: DBF . Commit

... 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 ...
by Carles
Mon Oct 23, 2023 4:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

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 ...
by Otto
Mon Oct 23, 2023 8:14 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

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.
by Enrico Maria Giordano
Mon Oct 23, 2023 7:34 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

... 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 ...
by nageswaragunupudi
Mon Oct 23, 2023 4:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

... 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 ...
by Otto
Sun Oct 22, 2023 10:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

... 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. ...
by Otto
Sun Oct 22, 2023 7:22 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

... 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 ...
by nageswaragunupudi
Sun Oct 22, 2023 2:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329

Re: DBF . Commit

... : " + 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 ...
by nageswaragunupudi
Sun Oct 22, 2023 2:09 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 5329
Next

Return to advanced search