Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBF is giving totally bizarre behavior
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
DBF is giving totally bizarre behavior
Divers
Thread ID:
00113439
Message ID:
00113439
Vues:
53
vfp 3.0 win95
the code below causes the index command to loop
it will prompt file exists do you want to overwrite?
and will not continue.
vfp then says it cannot access selected file.

I discovered that this dbf file did not have any
indexes, so I tried to create one and the above
is what is now occurring. any thoughts?

*******USE \INVOICES.DBF
INDEX ON workordern TO \INVNUM
SET ORDER TO INVNUM,ASCENDING

****select * from invoices where workordern = m.workordern ;
**** into cursor temp
****if _tally > 0
**** =messagebox('This invoice already exists!',16,'SERVTECH')
**** select invoices
**** locate for workordern = m.workordern
****else

*******SELECT INVOICES
INSERT INTO INVOICES FROM MEMVAR
REPLACE date WITH DATE()
*****SELECT INVOICES
****endif
****use in temp
****select invoices
****THISFORM.REFRESH
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform