Hi All

YET ANOTHER WEIRD RESPONSE!!!
I have a table called Assets with fileds named
Asset_no, Sub_no,Trans_sold, Sell_Date,Sell_price,Sell_reason

I have records like as in the above fileds :
00001,0, , , , ,
00001,1, , , , ,
00001,2, , , , ,
00002,0, , , , ,
00003,0, , , , ,
00003,1, , , , ,


When i Dispose of the asset I replace Trans_sold with "S", sell_date with a date,sell_price with a figure, and sell_reason with a code.

When I want to dispose of say for e.g asset_no '00003' and sub '1'
SQL 6.5 automatically disposes of both 00003,0 and 00003,1
WHY DOES IT DO THIS?

My statement reads :
masnum = '00003'
msub = '1'
select assets
set filter to asset_no = masnum .and. sub = msub
REPLACE trans_sold with 'S' for asset_no = masnum .and. sub = msub
replace sell_date with date() for asset_no = masnum .and. sub = msub
replace sell_price with 123.12 for asset_no = masnum .and. sub = msub
.....etc
set filter to


Thanks in advance
Fida