Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek gives index violation on buffered table
Message
De
08/07/2003 11:14:55
Geert Van Snik
Zorgned Automatisering Bv
Wageningen, Pays-Bas
 
 
À
08/07/2003 10:09:33
Geert Van Snik
Zorgned Automatisering Bv
Wageningen, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00807966
Message ID:
00808010
Vues:
33
I have put this code in a .prg and modified it a bit. This also gives the violation. Can anyone explain it?

open database zodata\zodata
close tables all

set deleted on

use indiziek
select indiziek
lnDummy=cursorsetprop("Buffering",5)

delete from indiziek where upper(clientnr+indicnr+kd_ziekte)==upper("944450 1B1.4 ")

? _tally &&This gives 1

SELECT IndiZiek
APPEND BLANK

REPLACE Clientnr WITH "944450",;
Indicnr WITH " 1",;
kd_Ziekte WITH "B1.4 ",;
Kd_Bron WITH "",;
BronAnders WITH "",;
Kd_Progn WITH "",;
Mate WITH "",;
Toelichtng WITH "",;
Datum_Diag WITH { - - }


set order to ix1
seek UPPER("944450 1B1.4 ") &&Here it generates index violation

close tables all
close databases all
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform