Re: [SQL] SQL INSERT/TRIGGER Help

2007-12-10 Thread Poovendran Moodley
Aww man thank you so much! It worked like a charm! Have a smashing day :D On Dec 10, 2007 9:43 AM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am Mon, dem 10.12.2007, um 9:27:58 +0200 mailte Poovendran Moodley > folgendes: > > I'm not really sure how to the currval() met

Re: [SQL] SQL INSERT/TRIGGER Help

2007-12-09 Thread Poovendran Moodley
- I just imitated an example I've seen. Thanks for your help Andreas, one step closer :) *currval()* is so much better than creating a view. Regards, Pooven On Dec 10, 2007 8:44 AM, A. Kretschmer < [EMAIL PROTECTED]> wrote: > am Mon, dem 10.12.2007, um 8:36:44 +020

[SQL] SQL INSERT/TRIGGER Help

2007-12-09 Thread Poovendran Moodley
Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of another table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table *Observation* *Time_Stamp* - *primary key* ..