Questions tagged as 'trigger'

Tagged questions
0
answers

IF with syntax error

I'm trying to create a simple chat system using database but I want it to automatically automatically truncate when it reaches a rows limit in the database. The trigger code I made was this: BEGIN SELECT COUNT(*) INTO @a FROM sandbox_we...
asked by 15.10.2016 / 17:20
0
answers

Trigger to update a field automatically after insert

I have a user table, basically: CREATE TABLE IF NOT EXISTS 'sistema'.'user' ( 'id_user' INT NOT NULL AUTO_INCREMENT COMMENT '', 'hashed_id' VARCHAR(40) NOT NULL COMMENT '', 'nome' VARCHAR(40) NOT NULL COMMENT '', 'cpf' VARCHAR(15) NOT...
asked by 20.09.2016 / 19:28
1
answer

How to create aTrigger After Update

I need to create a Trigger that performs an update on column A of table T, as soon as column B of this table is updated. So I believe I need to create an After Update. But from what I understand, it is not possible. When you try to do this, the...
asked by 03.08.2016 / 21:12
2
answers

Error executing a trigger

I have a problem with a trigger that when I make an insert of a record I want to automatically pass a value that comes by default is 1 to 0 only that is always giving this error. Can not update table 'receipts' in stored function / trigger b...
asked by 23.05.2016 / 18:57
0
answers

How to recompile all Views, procedures and triggers in Firebird?

I need to recompile all Views, procedures and triggers in Firebird, not by IBExpert, but by Delphi XE2, I will pass a SQL, I would like to know how to perform such a procedure.     
asked by 17.05.2016 / 19:16
1
answer

JPA Eclipselink - Trigger SQL SERVER

I'm having a problem with a trigger created in SQL SERVER. When I insert the data in the table that initiates the direct trigger in SQL SERVER the trigger works normal, however when done the insertion by JPA it presents an error and of the rollb...
asked by 18.06.2016 / 17:47
1
answer

Creation of Trigger for INSERT in another table in IBexpert

Good morning, I had the need to create a stock control, but I had never used a trigger. I have 3 tables COMPRA ABASTECIMENTO and MOVIMENTO_ESTOQUE Table MOVIMENTO_ESTOQUE : I would like that when I make...
asked by 15.02.2016 / 12:07
1
answer

Creating Trigger Sql Server

I am creating a trigger to create a copy of the changed data in the table. But you have an error. USE [BANCO1] GO /****** Object: Trigger [dbo].[BANCO1] Script Date: 08/07/2015 14:13:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON...
asked by 08.07.2015 / 19:15
2
answers

Trigger trigger click event does not work as expected

I'm using the Wordpress MetaSlider plugin for slides, and it's possible to add links to the images. I created a button and need to simulate click , just as I was clicking on the currently active image in the slider. I'm using trigger...
asked by 18.06.2015 / 02:04
1
answer

Trigger that feeds a table with information from the other MySQL

I have a database in MySQL with the Inventory, Sales and SalesIt tables. When you perform a sales record information on the Sales and SalesItems tables, but I want to get an information from the Inventory table and register on the Ite_Venda....
asked by 31.03.2015 / 14:05