Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>>I know we can lock, unlock, set multiple locks, and so on, now, can we actually count how many records are locked in a networked table? If I were to issue a command such as COUNT TO N FOR RLOCK() = .F. woudn't I be locking records as I'm counting?, it would make sense to me...then what would be the proper way to do this?
>>>
>>>Thanks, ladies and gentlemen...
>>
>>Gilberto, could you use Sys(2011)? It will give you the information you want, but I can't think how to use it except by checking every record....
>>
>>Barbara
>
>Barbara, I just tried using sys(2011) like this:
>
>USE CUSTOMERS &&with 150,000 records
>SET multilocks on
>GOTO 1200
>=rlock()
>GOTO 10000
>=rlock()
>GO top
>
>DO while .t.
> lcVar = sys(2011)
> IF upper(lcVar) = 'RECORD LOCKED'
> WAIT WINDOW 'Found one, continue: ' to cValue
> IF upper(cValue) = 'N'
> RETURN .f.
> ENDIF
> ENDIF
> Skip
>ENDDO
>CLOSE all
>
>and yes, it takes too much time, so if you find or hear a different way please let me know.
>
>Thanks,
Just for the record: try it with a SCAN instead of DO WHILE. It should be also very long, only not so long. :)
Vlad
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement