Brian If you are referring to the write statements it is because of the + and & You do not use the + or the & in write statements Write 'Customer Name :' .vTradenm Write 'Address :' .vStreet Write 'CSZ :' .vCity .vState .vZipcode Buddy
-----Original Message-----
From: [email protected] on behalf of Brian Mowers
Sent: Wed 1/26/2005 5:08 PM
To: RBASE-L Mailing List
Cc:
Subject: [RBASE-L] - Table look up in a Stored Procedure not working
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
Brian Mowers
[EMAIL PROTECTED]
<<winmail.dat>>
