Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
DBF is giving totally bizarre behavior
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
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