Hi Brian,
> 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
I don't think it hurts, but since there is only one table there is no
benefit in aliasing it (forget t1).
> Write 'Customer Name :'+.vTradenm
> Write 'Address :'+.vStreet
> Write 'CSZ:'+.vCity&.vState&.vZipcode
Try using parens:
set v vTestVar = ('Customer Name
:'+.vTradenm)
wri .vTestVar
Ben Petersen
On 26 Jan 2005 at 17:08, Brian Mowers wrote:
>
> 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]
