General information
Category:
Coding, syntax & commands
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only