[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