How to use variable of SQL query in IRD

[soyoung]

Hi...
Can you help me ?
I Want to insert to ANI in the database.

[b]Select * from dbo.aniTB Where Ani = ani[/b]<<<-----(variable of ani[] in IRD)

it is woking. i did get the name of the corresponding ani.
but, i can't  Insert Statement...


[b]Insert into  dbo.aniTB Values("ani") [/b]

that's okay ... as String "ani"
but i want to use ani as variable(variable of ani[] in IRD)

it could be used in Select query , but not working in Insert query

Do you know how to use variable??

Thank you..

[vmc]

Need to use a stored procedure and pass the variables to that.

Sent from my Redmi Note 3 using Tapatalk

[soyoung]

Thank you..!!

I done that!! i share my query


------------------------------------------------------------

<SQL server>

CREATE PROCEDURE InsertTB @a varchar(50), @b varchar(50)  AS
INSERT INTO dbo.aniTB(test1, test2) VALUES (@a, @b)


-------------------------------------------------------------

<IRD>

EXEC InsertTB @a = [b]ani[/b] , @b = [b]ConID[/b] <<----------(variables in IRD)

-----------------------------------------------------

[terry]

IRD automatically turns variables into values only if they follow some comparing/assigning sign like =, >, <, <=,  etc.