Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [Paul] Database Field Advice

Quote Reply
Re: [Paul] Database Field Advice In reply to
Thanks Paul.

That does make sense but I'm wondering what happens to the original records (each individual set of dates) in the table. Does the modify process overight and/or delete the original recods?

e.g If the original record is -

01/15,02/25,03/04,04/21,05/23,06/18,07/03,08/30

and then we modify it to -

01/15,02/25,03/04,04/21

what happens to the individual record for - 05/23,06/18,07/03,08/30?????

Would I need a PRE modify_record plugin that deletes ALL existing records before adding the new individual modified records.

Do you understand what I mean??

Thanks again.

Simon.
Subject Author Views Date
Thread Database Field Advice jai 3858 Jan 21, 2003, 3:33 AM
Post Re: [jai] Database Field Advice
jaspercram 3714 Jan 21, 2003, 7:27 AM
Thread Re: [jai] Database Field Advice
Paul 3713 Jan 21, 2003, 8:44 AM
Thread Re: [Paul] Database Field Advice
jai 3689 Jan 24, 2003, 4:09 PM
Thread Re: [jai] Database Field Advice
Paul 3687 Jan 24, 2003, 4:14 PM
Thread Re: [Paul] Database Field Advice
jai 3685 Jan 24, 2003, 5:35 PM
Thread Re: [jai] Database Field Advice
Paul 3700 Jan 24, 2003, 5:46 PM
Post Re: [Paul] Database Field Advice
jai 3656 Jan 26, 2003, 11:15 PM
Post Re: [Paul] Database Field Advice
jai 3647 Jan 28, 2003, 8:59 PM