Trigger error

Hi,

I have written a trigger and now im getting this error when i try to add it to my database.

ERROR 1415 (0A000): Not allowed to return a result set from a trigger

What does that mean?

Jan 9 '08 #1

Follow Post Reply

2131

tb1

never mind. i figured it out myself. i created a stored procedure to get around this error.

Jan 9 '08 #2

Similar topics

Microsoft SQL Server

Error with the trigger

3 posts views Thread by Michael Teja via SQLMonster.com | last post: by

Microsoft SQL Server

Raising Error from Trigger to Stored Proc

1 post views Thread by Jen S | last post: by

DB2 Database

V5R2 DB2/UDB iSeries: can a system trigger call a SQL stored proc?

reply views Thread by Dave Sisk | last post: by

DB2 Database

trigger question

4 posts views Thread by Alexander Pope | last post: by

DB2 Database

Mysterious Trigger error DB2 UDB v8.1.5

12 posts views Thread by Bob Stearns | last post: by

DB2 Database

Trigger structure

5 posts views Thread by Bob Stearns | last post: by

C# / C Sharp

Advanced - C# SQL Trigger Question

3 posts views Thread by ChrisN | last post: by

PostgreSQL Database

Error loading trigger in C

2 posts views Thread by Juan Jose Costello Levien | last post: by

PHP

How to trigger an error inside a function and make it come from whereit was called?

5 posts views Thread by Bruno Rafael Moreira de Barros | last post: by

Oracle Database

HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist

11 posts views Thread by tracy | last post: by

Software Development

What Makes Product Development Lean?

1 post views Thread by beacampos | last post: by

Web Applications

How PDDON's online drawing surprised you?

reply views Thread by pddon | last post: by

General

create a game with ps3 style graphics by myself, is it possible? how can I do it?

reply views Thread by BenitoJuares | last post: by

PHP

How do we call a function with parameters and use output returning true/false in php?

reply views Thread by bakertaylor28 | last post: by

General

openGauss security policy

reply views Thread by leo001 | last post: by

General

Forrester: Four Digital Intelligence Products of AsiaInfo Included in China Data Governance Ecology Report

reply views Thread by antdb | last post: by

General

Top Notch! AntDB database of AsiaInfo passed authoritative test of MIIT

reply views Thread by antdb | last post: by

Microsoft Access / VBA

Automatically Relink Frontend to 2 Backends via form

3 posts views Thread by bobbyer | last post: by

Microsoft Access / VBA

Group serial number

3 posts views Thread by Bright1Light | last post: by

Post your reply

Similar topics