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 5332 Jan 21, 2003, 3:33 AM
Post Re: [jai] Database Field Advice
jaspercram 5147 Jan 21, 2003, 7:27 AM
Thread Re: [jai] Database Field Advice
Paul 5155 Jan 21, 2003, 8:44 AM
Thread Re: [Paul] Database Field Advice
jai 5131 Jan 24, 2003, 4:09 PM
Thread Re: [jai] Database Field Advice
Paul 5131 Jan 24, 2003, 4:14 PM
Thread Re: [Paul] Database Field Advice
jai 5130 Jan 24, 2003, 5:35 PM
Thread Re: [jai] Database Field Advice
Paul 5143 Jan 24, 2003, 5:46 PM
Post Re: [Paul] Database Field Advice
jai 5089 Jan 26, 2003, 11:15 PM
Post Re: [Paul] Database Field Advice
jai 5079 Jan 28, 2003, 8:59 PM