Re: [sqlite] Re: Adding columns of records and updating the result to a record

2007-03-16 Thread jose isaias cabrera
Thank you, John. This helps a lot. josé - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Friday, March 16, 2007 12:19 AM Subject: Re: [sqlite] Re: Adding columns of records and updating the result to a record When you design a database d

Re: [sqlite] Re: Adding columns of records and updating the result to a record

2007-03-15 Thread John Stanton
When you design a database do not mix record (row) structures in a single table (variant records). That used to be done with ISAM files but is no longer necessary with the advent of the RDBMS. Also you should design your database to have "Third Normal Form" which means that each data item is o

Re: [sqlite] Re: Adding columns of records and updating the result to a record

2007-03-15 Thread jose isaias cabrera
"Igor Tandetnik" wrote, jose isaias cabrera <[EMAIL PROTECTED]> wrote: I have a system that links two or more records to one head record using a column called ProjID, where ProjID has the unique recNO of the head record. Anyway, what I would like to do is something like this... Imagine, re

[sqlite] Re: Adding columns of records and updating the result to a record

2007-03-15 Thread Igor Tandetnik
jose isaias cabrera <[EMAIL PROTECTED]> wrote: I have a system that links two or more records to one head record using a column called ProjID, where ProjID has the unique recNO of the head record. Anyway, what I would like to do is something like this... Imagine, recNo,ProjID,Invoice,Fund 1,1