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