Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Andrus,
In stead on using a RLOCK(), you might want to try a FLOCK() or alternatively close it and use the table again before you issue the SQL-SELECT
Walter,
>I have a shared non buffered dbf file. I need to get latest data from it using SQL SELECT command.
>
>I have a command
>
>SET REFRESH TO 0,1
>
>in my form init.
>
>If records are added to this shared dbf file by other instance of VFP,
>SQL SELECT in another instance does not find added rows.
>
>This occurs on LAN or if two vfp programs are running on local computer using same dbf file.
>
>I discovered that adding a line
>
>inkey(1.5)
>
>before SQL SELECT fixes this behaviour: SELECT then returns latest data.
>
>However, adding inkey(1.5) 's before SELECTs decreases program speed.
>
>How to force VFP to refresh its local buffers immediately ?
Précédent
Suivant
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