General information
Category:
Coding, syntax & commands
Cetin,
Code should only run once, but it is looping for
some reason, over and over again.
>>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
>Hi Rebecca,
>Is there any mistyping here and where this code belongs to ? Is "index on" command part of code or run once ?
>Cetin
Previous
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