Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBF is giving totally bizarre behavior
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
DBF is giving totally bizarre behavior
Miscellaneous
Thread ID:
00113439
Message ID:
00113439
Views:
54
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
Map
View

Click here to load this message in the networking platform