[Babase] updating a range of records

kfenn kfenn at princeton.edu
Mon Nov 19 11:56:34 EST 2007


Hi Karl,

Laurence will be periodically updating the dates in a small range of 
fecal table records.  I think the way for her to do this is to use the 
UPDATE command and use the sid to specify the records she wants to alter.

In FoxPro, she was able to use a "Replace with" dialog box that asked 
her to specify a starting point and give a numeric value for the number 
of  subsequent records she wanted to fill in with her new value.  Is 
there any equivalent in SQL that would let her say  do the same thing.  
That is, to say "Start with this record, in this column and fill in 
such-and-such for the next 7 records"....or is UPDATE the way to go?


Tabby

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list