, 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
-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
update on the same
table that I wanted the trigger to act on.
Please let me know if I am way off in regards to triggers.
thanks,
Kurt
-Original Message-
From: Antoine Reid [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 15, 2000 2:43 PM
To: Madel, Kurt
Cc: [EMAIL PROTECTED]
Subject: Re
Hello,
I am creating a web based (using php) class registration database with three
tables directly effected by the registration process:
1) class
2) student
3) module
The module table has a field for every module (or class period) for every
student that registers for a given year. When a stud
I am trying to create a rule that will increment the class.size in one table
when a student adds that class to their schedule in another table (module).
Basically, there are 3 tables involved:
class
module
student
When a student registers for their classes, the class.id is placed in its
respecti
Hello,
I am trying to create a RULE that updates the size of a class when a student
registers for that class and the register(module) table is updated, and
subtract 1 from the given class size when a student drops a course.
Actually, there is a class table and a module table. The class table's
p
