>>>I have about 1000 records in a table ordered by the mainkey field. i.e.
>>>
>>>
>>>Mainkey
>>>---------
>>>Neil01 Cutting
>>>Neil02 Costing
>>>Neil02 Made
>>>Neil02 Sent
>>>
>>>
>>>everytime the mainkey changes when I scan down the table I want to append a record in another table with the value of mainkey.
>>>
>>>How can i do this easily??
>>
>>SELECT YourTable
>>lc_Mainkey = YourTable.Mainkey
>>SCAN
>> IF lc_Mainkey # YourTable.Mainkey
>> INSERT INTO othertable ....
>> lc_Mainkey = YourTable.Mainkey
>> ENDIF
>> ...
>>ENDSCAN
>>
>
>Vlad,
>A small correction:
>
>lc_Mainkey = ''
>SCAN
> IF !(m.lc_Mainkey == YourTable.Mainkey)
>
Cetin
I agree with the correction.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst