TRIGGER

12/02/2007 - 23:32 por GAEJ | Informe spam
Hola a todos, soy principiante en todo esto, me gustaria si alguien puede
aclarame esta duda. Intento Extraer datos de una tabla mediante un TRIGGER
pero no puedo hacerlo trabajar les expongo lo que estoy usando esperando em
puedan ayudar. gracias.

Alter Trigger InvoicesExchange
On [Dbo].[Factura]
After Insert, Update, Delete

Declare @IdInvoice As Varchar (20)
Declare @IdOrder Varchar (20)
Declare @DateInvoice DateTime (8)
Declare @PaymentDay DateTime (8)
Declare @TotalAmount Money (8)
Declare @ShippingCost Money (8)
Declare @RemainderAmount Money (8)
Declare @ShipmentStatus Int (4)
Declare @PaidInvoice Bit (1)
Declare @PaidCommission Bit(1)
Declare @ArrivalDate DateTime (8)
Declare @IdTransport SmallInt (2)
Declare @TransactionType Int (4)
Declare @TimeStamp DateTime (8)

Select @IdInvoice = (Select K_Factura From Inserted)
Select @IdOrder = (Select K_Pedido From Inserted)
Select @DateInvoice = (Select F_Factura From Inserted)
Select @PaymentDay = (Select F_Vencimiento From Inserted)
Select @TotalAmount = (Select Monto From Inserted)
Select @ShippingCost = (Select Flete From Intserted)
Select @RemainderAmount = (Select Saldo From Inserted)
Select @ShipmentStatus = (Select Estatus_Envio From Inserted)
Select @PaidInvoice = (Select Pagada From Inserted)
Select @PaidCommission = (Select Comision_Pagada From Inserted)
Select @ArrivalDate = (Select F_Llegada_Aduana From Inserted)
Select @IdTransport = (Select K_Trasnporte From Inserted)

Begin
Insert InTo InvoiceExchange(IdInvoice, IdOrder, DateInvoice, PaymentDay,
TotalAmount, ShippingCost, RemainderAmount, ShipmentStatus,
PaidInvoice, PaidCommission, ArrivalDate, IdTransport)

Values (@IdInvoice, @IdOrder, @DateInvoice, @PaymentDay, @TotalAmount,
@ShippingCost, @RemainderAmount, @ShipmentStatus, @PaidInvoice,
@PaidCommission, @ArrivalDate, @IdTransport)
End
 

Leer las respuestas

#1 Isaias
13/02/2007 - 00:02 | Informe spam
A ver, pongamonos de acuerdo

Un trigger solo trabaja en el momento para el cual fue creado, en tu caso,
para un DELETE, INSERT o UPDATE, ¿De acuerdo?

Pero, estas insertando en la misma tabla !!!!

¿Que es lo que quieres hacer exactamente?
Saludos
IIslas


"GAEJ" wrote:

Hola a todos, soy principiante en todo esto, me gustaria si alguien puede
aclarame esta duda. Intento Extraer datos de una tabla mediante un TRIGGER
pero no puedo hacerlo trabajar les expongo lo que estoy usando esperando em
puedan ayudar. gracias.

Alter Trigger InvoicesExchange
On [Dbo].[Factura]
After Insert, Update, Delete

Declare @IdInvoice As Varchar (20)
Declare @IdOrder Varchar (20)
Declare @DateInvoice DateTime (8)
Declare @PaymentDay DateTime (8)
Declare @TotalAmount Money (8)
Declare @ShippingCost Money (8)
Declare @RemainderAmount Money (8)
Declare @ShipmentStatus Int (4)
Declare @PaidInvoice Bit (1)
Declare @PaidCommission Bit(1)
Declare @ArrivalDate DateTime (8)
Declare @IdTransport SmallInt (2)
Declare @TransactionType Int (4)
Declare @TimeStamp DateTime (8)

Select @IdInvoice = (Select K_Factura From Inserted)
Select @IdOrder = (Select K_Pedido From Inserted)
Select @DateInvoice = (Select F_Factura From Inserted)
Select @PaymentDay = (Select F_Vencimiento From Inserted)
Select @TotalAmount = (Select Monto From Inserted)
Select @ShippingCost = (Select Flete From Intserted)
Select @RemainderAmount = (Select Saldo From Inserted)
Select @ShipmentStatus = (Select Estatus_Envio From Inserted)
Select @PaidInvoice = (Select Pagada From Inserted)
Select @PaidCommission = (Select Comision_Pagada From Inserted)
Select @ArrivalDate = (Select F_Llegada_Aduana From Inserted)
Select @IdTransport = (Select K_Trasnporte From Inserted)

Begin
Insert InTo InvoiceExchange(IdInvoice, IdOrder, DateInvoice, PaymentDay,
TotalAmount, ShippingCost, RemainderAmount, ShipmentStatus,
PaidInvoice, PaidCommission, ArrivalDate, IdTransport)

Values (@IdInvoice, @IdOrder, @DateInvoice, @PaymentDay, @TotalAmount,
@ShippingCost, @RemainderAmount, @ShipmentStatus, @PaidInvoice,
@PaidCommission, @ArrivalDate, @IdTransport)
End

Preguntas similares