Hi Scott. I'm not familiar with LVs Database Toolkit, but I can try to
address your question from a pure SQL standpoint. Maybe you already
figured this out, but:
You don't always have to write a full row to a table. As long as the
the columns you will be writing to are designed with ALLOW NULL or given
a DEFAULT value.
Your first write should creat the new row using an INSERT statement such
as:
INSERT INTO mytable values (testtime) values ('12:00')
The empty rows will be NULL or contain the DEFAULKT you specified when
creating the table. And then the next column should be written with an
UPDATE statement:
UPDATE mytable SET serialnum = 100100 WHERE testtime = '12:00'
Though, in reality, you should use something else beside time to
identify the row you are updating.
And the next columns are written as:
UPDATE mytable SET serialnum = 100100 WHERE testtime = '12:00'
UPDATE mytable SET serialnum = 100100 WHERE testtime = '12:00'
PS. The SQL statements above might need to be tweeked for us on Oracle.
Hope that helps a bit.
***********************************
John Paul Osborne
http://members.aol.com/josborne01
***********************************
Scott Serlin wrote on 1/9/2004, 8:50 PM:
> Can anyone tell me if it is possible to treat an Oracle database like
> a giant array? More to the point, do I have to always write a
> complete record (or row) of data into a table or is there a way to
> place a piece of data into one single column within the row and come
> back later and place a different piece of data in the same row but
> different column?
>
> Example:
> I wrote the first piece of data like this:
>
> Table
> testtime testdate dut serialnum productline
> 12:00
>
>
> Later on I wanted to add another data point in the same row but
> different column while still maintaining the data previously entered:
>
> Table
> testtime testdate dut serialnum productline Can I do this? Is it
> allowed in Oracle?
> 12:00 100100
>
> Once the row is complete, I would move onto the next row.
>
> Table
> testtime testdate dut serialnum productline
> 12:00 010603 1 100100 widget
> 1:00 010603 2 100101 widget
>
>
>
>
>
