RE: triggers and references.

2002-01-10 Thread Matthew Darcy
Darcy Cc: MySql List Subject: Re: triggers and references. On Thu, Jan 10, 2002 at 02:48:26PM -, Matthew Darcy wrote: > > in Oracle I have a test database. there are 2 tables table1 and > table2. > > there is a field on both tables called account_number. on table 1 it > is set

RE: triggers and references.

2002-01-10 Thread Matthew Darcy
[mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 15:30 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: triggers and references. The many simple questions you ask imply that you have not read the manual. Triggers are not supported. Matthew Darcy wrote: > >Hi, > >in Oracle I

Re: triggers and references.

2002-01-10 Thread Gerald Clark
The many simple questions you ask imply that you have not read the manual. Triggers are not supported. Matthew Darcy wrote: > >Hi, > >in Oracle I have a test database. there are 2 tables table1 and table2. > >there is a field on both tables called account_number. on table 1 it is set >to auto i

Re: triggers and references.

2002-01-10 Thread Jeremy Zawodny
On Thu, Jan 10, 2002 at 02:48:26PM -, Matthew Darcy wrote: > > in Oracle I have a test database. there are 2 tables table1 and > table2. > > there is a field on both tables called account_number. on table 1 it > is set to auto increment. > > I have set up a trigger so that when a number is

triggers and references.

2002-01-10 Thread Matthew Darcy
Hi, in Oracle I have a test database. there are 2 tables table1 and table2. there is a field on both tables called account_number. on table 1 it is set to auto increment. I have set up a trigger so that when a number is generated in table1 it copies the number to account_number on table 2. C