Re: need help with sequence

a sequence won't be appropriate for the votes column

if you mean you want to increment the value of the votes column in an existing row, just do an update and set vote = vote + 1 (or whatever increment is appropriate)

;-{ mcs

"Karl Hungus" <nnnnndddddd_at_hotmail.com> wrote in message news:bdP_b.222$1e3.151470_at_twister.nyc.rr.com...
|
| I just want to increment the votes column. There will only be one poll.
|
|
| > typically one sequence is created for each system-assigned PK (or UK)
| > constraint -- so for PERSON_ID you just need one sequence
| >
| > however, your intention is not quite clear -- do you intend to create a
| new
| > record for each 'batch' of votes (multiple poll records per PERSON_ID)
or
| > do you just want to increment the VOTES column? sounds like you probably
| > need at least three tables: PERSONS, POLLS, POLL_RESULTS
| >
| > ;-{ mcs
| >
| >
|
|
Received on Tue Feb 24 2004 - 15:30:46 CST