1. You could add two columns to the table (eg. CurRowID and PrevRowID) and update these with its rowID and RowID - 1,
3. Then make a selection of the whole table into a query name
4. then update the table by joining the table to this query using CurRowID = PrevRowID to add the column z to that table as a temporary column.
5. The do the update as you suggested.
I tried this using temporary columns all the way, but eventually MI said you could use the temporary columns in the join, so I suspect that you need to add at least one hard column.
R
On Wed, 5 Nov 2003 10:33:14 -0900, Declan Troy <[EMAIL PROTECTED]> wrote:
Not sure if this is possible or just a syntax issue. Is there a way to update a column using a value in a different row.
Something to the effect of update mytable set X = Y + Z(ROWID-1)
Any suggestions?
declan
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9039
--
Robert Crossley Agtrix P/L 9 Short St New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9040
