My scan on scrental actually goes through all records. I don't think my sccust file goes to EOF, am I correct in assuming the only file that would go to EOF would be scautopy in this example?
or am I probably confused!
>When you insert, The record pointer will Be at EOFAfter your insert, your scan will terminated and your relation will not work since your cus_acct is empty )At Eof)
>
>
>
>>I have established a temporary relationship between 2 tables(scrental and sccust).
>>
>>as I scan through scrental, the pointer in sccust moves correctly, until I put an insert...values command within the scan. Then the pointer in sccust no longer moves correctly. Here is the code: If I remove the insert command and only leave the messagebox then it works correctly.
>>
>>
>>select sccust
>>set order to cus_acct
>>select scrental
>>set relation to rnt_acct into sccust
>>
>>select scrental
>>scan
>> messagebox(sccust.cus_ccno)
>> insert into scautopy (aut_pk) ;
>> values(padl(x3genpk("scautopy","sc"),5,"0"))
>>endscan
>>
>>
>>Any ideas?
>>
>>Thanks,
>>Paul