Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
On Tue, Aug 15, 2000 at 02:52:24PM -0400, Madel, Kurt wrote: > Hello Antoine, > > I thought that triggers only worked for one table at a time. In this case, > I want the class.size incremented and checked for maxsize when I perform an > update or insert on the module table. I was under the impr

Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
On Tue, Aug 15, 2000 at 01:57:17PM -0400, Madel, Kurt wrote: > Hello, > > I am creating a web based (using php) class registration database with three > tables directly effected by the registration process: [snip] > My question is, would it be better (faster) to use rules or to use a > transact

Re: [SQL] Use a rule or a transaction

2000-08-15 Thread Antoine Reid
On Tue, Aug 15, 2000 at 03:38:09PM -0400, Madel, Kurt wrote: > Hey Antoine, > > I am using 7.0.2, and I would be in your debt if you created a working > example. Basically, the structure of the query I would like to do is as > such (there are six modules in the module table for each quarter: > a

RE: [SQL] Use a rule or a transaction

2000-08-15 Thread Jesus Aneiros
t; > -Original Message- > From: Antoine Reid [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 15, 2000 2:43 PM > To: Madel, Kurt > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] Use a rule or a transaction > > > On Tue, Aug 15, 2000 at 01:57:17PM -0400, Madel, Kurt wrot

RE: [SQL] Use a rule or a transaction

2000-08-15 Thread Madel, Kurt
, August 15, 2000 3:49 PM To: Madel, Kurt Cc: 'Antoine Reid'; [EMAIL PROTECTED] Subject: Re: [SQL] Use a rule or a transaction On Tue, Aug 15, 2000 at 03:38:09PM -0400, Madel, Kurt wrote: > Hey Antoine, > > I am using 7.0.2, and I would be in your debt if you created a working

RE: [SQL] Use a rule or a transaction

2000-08-15 Thread Madel, Kurt
-Original Message- From: Antoine Reid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 15, 2000 3:04 PM To: Madel, Kurt Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Use a rule or a transaction On Tue, Aug 15, 2000 at 02:52:24PM -0400, Madel, Kurt wrote: > Hello Antoine, > > I thought that

RE: [SQL] Use a rule or a transaction

2000-08-15 Thread Madel, Kurt
: [SQL] Use a rule or a transaction On Tue, Aug 15, 2000 at 01:57:17PM -0400, Madel, Kurt wrote: > Hello, > > I am creating a web based (using php) class registration database with three > tables directly effected by the registration process: [snip] > My question is, would it be