FiveTech Software tech support forums

then DO WHILE !oPermessi:EoF() oPermessi:Lock() oPermessi:Exec( { || DELETE FOR oPermessi:Usuario==oUtenti:Clave } ) oPermessi:Unlock() oPermessi:Skip() ENDDO is it right ? make me error source\test.prg(688) Error E0030 Syntax error "syntax error at 'FOR'" 1 error No, it's not ...

then DO WHILE !oPermessi:EoF() oPermessi:Lock() oPermessi:Exec( { || DELETE FOR oPermessi:Usuario==oUtenti:Clave } ) oPermessi:Unlock() oPermessi:Skip() ENDDO is it right ? make me error source\test.prg(688) Error E0030 Syntax error "syntax error at 'FOR'" 1 error

Silvio.Falconi wrote:Nages,
someone (an american boy) sad me not use lock and unlock (and commit) because
tdatabase make it auto.

Not FLOCK

Nages,
someone (an american boy) sad me not use lock and unlock (and commit) because
tdatabase make it auto.

When you want to delete multiple records for a given condition

oDbf:Lock()
oDbf:Exec( { || DELETE FOR <cond> } )
oDbf:Unlock()

Ya encontré en el foro la solucion: //To "Lock" or "Unlock" a cell use: oSheet:Range("A1","A10"):Locked:=.f. //(or .t. to lock) //Then to protect the locked cells: oSheet:Protect( "12345") //To Unprotect the ...

... file. The 1-st action is executed also by any other rdd operation which may cause record reloading or may need to synchronize modifications, f.e. unlock. You can simulate it in many different ways, f.e. by skip(0). The 2-nd action is unique to dbcommit and it's not necessary for any synchronizations ...

... vacios, yo he trabajado con dbf en red años y no he tenido ese problema solo usaba los comandos basicos: rlock() para bloquear registros, unlock() para desbloquear el registro, append() para añadir nuevo registros Otra opcion podrias probar con DATABASE aqui en el foro hay bastantes ejemplos

... si SELECT() si SELECT(“CLIENTES”) si SET FILTER ? SET SCOPE TO ( cSERIE + StrZero( NUMERO_ORI,20 ) ) ? SUM CLIENTES->IMPORTE TO Ntotal ? UNLOCK ALL si ZAP La "?" no significa que no esté si no que no lo he probado aún. En cuanto a lo indices el concepto en SQL es ordenancion ...

I use rlock() and unlock.

Also, DbInfo( DBI_ISFLOCK ) works.

Hello Marc,

I don't sure, but I think one way can be to lock a record in a table (dbf) users while the user is logged, when the user logout, unlock the record, I think (no sure) when client lost the conection, the record is unlocked automatlicaly, you can test

saludos

Marcelo

... comprobar si lo ha conseguido. APPEND BLANK IF !NETERR() // ... ELSE ? "Error en bloqueo " ENDIF Y ojo no te olvides de efectuar unlock después . Saludos José. Enviado desde mi POCOPHONE F1 mediante Tapatalk

... 5 except for the details on resitems.dbf first deleting all the records with the number nInvoice and then inserting all the content in aItems 5 unlock the record in reserva.dbf

... the record on reserva.dbf 2) upload the invoice details to aItems 3) work on xbrowse 4) save on Resitems.dbf 5) save the record on reserva.dbf 6) unlock the record on reserva.dbf but I still haven't figured out how I can do it

Hello, I would like to use the USB HUB for a security solution. Therefore I asked the producer if there is a USB HUB where you need a password to unlock the port. ykushcmd.exe -d 3 PW xxxtest Without knowing the PW or the serial number, unlocking should not be possible. To copy ykushcmd.exe and ...