Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
ct the maximum check shouldn't be too hard either.. Oh BTW, this should work on 7.0.2, probably on 7.0; I really don't know about 6.x.x.. hope this helps antoine -- o Antoine Reid o>Alcohol and calculus <|> [EMAIL PROTECTED] <|don't mix. Never drink | >\[EMAIL PROTECTED] >\ and derive. /<

Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
ules or a better way to do it > otherwise. > > TIF, > Kurt Hope it helps Antoine -- o Antoine Reid o>Alcohol and calculus <|> [EMAIL PROTECTED] <|don't mix. Never drink | >\[EMAIL PROTECTED] >\ and derive. /<

Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
decrement the old class, and increment the new one. The triggers on classes will already check that the new one is not already full.. - The trigger on INSERT on modules should return an error if the class_id does not exist.. These are left as an exercise to the reader... (especially because i'm not sure how to do that last one... :-> ) > Thanks, > Kurt hope this helps antoine -- o Antoine Reid o>Alcohol and calculus <|> [EMAIL PROTECTED] <|don't mix. Never drink | >\[EMAIL PROTECTED] >\ and derive. /<

Re: [SQL] confused by select.

2000-07-07 Thread Antoine Reid
open' orders, inventory, etc and another set of tables, that are populated for every invoice. (Yes, that means lots of duplication..) > > Hoping it may help > > Patrick JACQUOT > just my 1/50$ CDN (for what it's worth nowadays...) Antoine Reid