Hi Jim
I think you can try this :
select * from mytable where mycriteria > 15 into anothertable
update anothertable set myfield2 = myfield1*myfield3
Those lines will append the column _col2 in my table
Hope it could help you
stephane
> Jim Wilson a écrit :
>
> Hi all,
>
> I'm (slowly) learn
Jim
Just
remove all the 'looping' code - the update command will work on an entire
selection/table unless you use the optional where clause. No 'do whiles'
needed! Therefore all you need to use is:
Select *
From Tablename Where _col1< 15
Update Selection Set _col1 = _col2
that
Hi Jim
just write this
Select * from MyTab Where _Col2 < 15 into MySelection NoSelect
Set table MyTable Fastedit on
Update MySelection set _col2 = _col3 * _col1 ' this line do the
update
Commit table MyTab
Close table MySelection
Set table MyTAble fastedit off
The Set table mytabel