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 *
FromTablename Where_col1 15
Update Selection Set _col1 = _col2
that's
bcc: Peter Laulund/MI/KMS)
Vedrørende:MI Updating columns in Mapbasic
Hi all,
I'm (slowly) learning mapbasic and I'm trying to update the value of _col2
based on the number in _col3 * _col1. To this end I have tried 2 different
ways of achieving this.
1. Select all the records in Tablename
Hi
all,
I'm (slowly)
learning mapbasic and I'm trying to update the value of _col2 based on the
number in _col3 * _col1. To this end I have tried 2 different ways of achieving
this.
1. Select all the
records in Tablename that fall within certain parameters and then update
Tablename from
