Why VFP locks this table?  
Author Message
Aleniko29139





PostPosted: Visual FoxPro General, Why VFP locks this table? Top

I have the following code:

SET EXCLUSIVE OFF
CLOSE DATABASES ALL

USE KRCBP!RUGINV ORDER RUGNO IN 0
USE TMPRUG IN 0

SELECT TMPRUG
SET RELATION TO RUGNO INTO ruginv
BROWSE FIELDS RUGNO,DESIGN=ruginv.DESIGN


When the user starts typing in the first field (rugno, in the tmprug table), it locks the ENTIRE second file (ruginv). The lock gets released only when moving the record pointer.

Any ideas why VFP locks the second file Is there a way out of this

Thanks.




Visual FoxPro1  
 
 
Aleniko





PostPosted: Visual FoxPro General, Why VFP locks this table? Top

I'm still not sure why VFP lock the related file, but I have found a solution.

BROWSE FIELDS RUGNO,DESIGN=getfval("ruginv.DESIGN")

procedure getfval
parameters cField
return &cField

No files locked anymore.