Re: need help with sequence

From: Karl Hungus <nnnnndddddd_at_hotmail.com>
Date: Tue, 24 Feb 2004 21:19:03 GMT
Message-ID: <bdP_b.222$1e3.151470@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:19:03 CST