>>I've run into a weird problem I can't seem to figure out. I have a table that is opened in dataenvironment of the form with an initial index tag. When I try to insert new records with "INSERT INTO...", it gives me an "Index tag not found!" error. I'm looping through a temporary cursor on the form and adding records from this cursor. My code looks something like this:
>>
>>SELECT invt
>>SET ORDER TO TAG "refno" &&my table's primary key tag which I'm changing from another tag
>>SELECT cNStyle && cursor
>>SCAN
>> IF EMPTY(cNStyle.refno)
>> *-- THIS IS WHERE ERROR MESSAGE APPEARS!!!
>> INSERT INTO invt (field1,etc...) VALUES (cNStyle.field1, etc...)
>> ELSE
>> SELECT invt
>> IF SEEK(cNStyle.refno)
>> REPLACE field1 WITH cNStyle.field1
>> ....
>> ENDIF
>> SELECT cNStyle
>>ENDSCAN
>>
>>Any suggestions?
>>TIA, John
>
>Don't use quotes:
>SET ORDER TO TAG refno
Edward,
Thanks for the suggestion. I've always used quotes for tag w/o any problems before. I don't think it matters either way. Anyway, I've tried your suggestion but it didn't help. I'm still getting same "Index tag not found" error. In addition, if the line SET ORDER TO TAG "refno" was the problem I should only get one error message on that line. However, if I'm adding 3 records, I get the error message 3 times for each INSERT command. Anymore suggestions???
Thanks again. John