Hi,
I am testing a Stored Procedure and can get a variable to fill from the table the SP is based on, but when I try to fill variables
from another table in the same database it doesn't work. Here is the SP file and the text output:
Any ideas
*(After Insert Trigger Sample.PRC)
OUTPUT B.TXT
SET ECHO OFF
*(assume the table is called Dummy)
SELECT Dummy INTO vDummy vi1 FROM Dummy WHERE CURRENT OF SYS_NEW
SET VAR vIntegerValue TEXT = ('This value Was Just Inserted Into Dummy Column :' + (CTXT(.vDummy)))
SHOW VAR vIntegerValue
WRITE 'This is from an After Insert Trigger'
Select T1.Tradenm,T1.Account,T1.Street,T1.City,T1.State,T1.Zipcode INTO +
vTradenm i1,vAccount i2,vStreet i3,vCity i4,vState i5,vZipcode i6 From +
Customer T1 Where T1.Account=1
Write 'Customer Name :'+.vTradenm
Write 'Address :'+.vStreet
Write 'CSZ :'+.vCity&.vState&.vZipcode
OUTPUT SCREEN
SET ECHO OFF
RETURN
--------Output from B.Txt File---------------------
This value Was Just Inserted
Into Dummy Column :21
This is from an After Insert Trigger
Customer Name : +.vTradenm
Address : +.vStreet
CSZ : +.vCity&.vState&.vZipcode
[EMAIL PROTECTED]
