469,575 Members | 1,717 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Problem in Creating AFTER INSERT Trigger

I am trying to create a AFTER INSERT Trigger. I created it and it worked for one record. But when I am trying to input multiple inserts it gives me error even on my insert statement. I am sure the syntax is right. Can anyone confirm this syntax. When I created a small table for testing this syntax worked... I dont know why its not working here.


INSERT INTO media (
media_name,
description,
active_flag,
activity_log,
data_entry_status_code,
category_id,
vendor_id,
created_by,
created_date
)
VALUES
('Test Media20', 'Test Description20', 1, 'Test Log20', 1, -1, -1, -1, '1/1/2001 12:00:00 AM'),
('Test Media21', 'Test Description21', 1, 'Test Log21', 1, -1, -1, -1, '1/1/2001 12:00:00 AM'),
('Test Media22', 'Test Description22', 1, 'Test Log22', 1, -1, -1, -1, '1/1/2001 12:00:00 AM')
Apr 2 '07 #1
2 1943
iburyak
1,017 Expert 512MB
It is an insert statement.
Show me trigger text, please and what error messages you have if any.
Apr 2 '07 #2
iburyak
1,017 Expert 512MB
Also what is table [media] definition?
I mean show me datatypes of your columns.
Apr 2 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by gimme_this_gimme_that | last post: by
2 posts views Thread by mob1012 via DBMonster.com | last post: by
11 posts views Thread by Ed Dror | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.