On Tue, 14 Oct 2003 15:10:50 -0500 "NIPP, SCOTT V (SBCSI)"
<[EMAIL PROTECTED]> wrote:
> Wow. That sounds really cool, but unfortunately, I don't have a
> clue what language you are speaking. I am an SA doing some web
> development and automation work for our group. I am by no means a
> DBA, and
NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] wrote:
> I am working on an application that has a database table with two
> repeating fields. The table has several fields that are uniq, and the there
> are two fields that occur 6 times i.e. a1, b1, a2, b2, ., a6, b6. This
> table is populated
On Tue, 14 Oct 2003 14:15:55 -0500 "NIPP, SCOTT V (SBCSI)"
<[EMAIL PROTECTED]> wrote:
> I am working on an application that has a database table with two
> repeating fields. The table has several fields that are uniq, and the
> there are two fields that occur 6 times i.e. a1, b1, a2, b2,
One solution would be to add an extra column to the end of the table: ACTIVE_N
if ACTIVE_N = 3, then you add data into a3 and b3, and so forth.
If ACTIVE_N > 6, then you go ahead and delete the appropriated field pairs to
make room.
Paul
Quoting "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>:
>
I am working on an application that has a database table with two
repeating fields. The table has several fields that are uniq, and the there
are two fields that occur 6 times i.e. a1, b1, a2, b2, ., a6, b6. This
table is populated and updated from a Perl script that parses a file. A
