AnsweredAssumed Answered

pass process var to sql statement

Question asked by yasha01 Employee on Oct 30, 2012
Latest reply on Oct 31, 2012 by john.richardson2.2
Hi there;

A quick question how to pass process var or user defined var to sql statement of database operations.

What I'd like to do is like , for example, to pass the user name from Process to sql.

set @var1 = Process.user;
select * from test where user = @var1;
(test table include user field.)


Cheers;
-H. Yasu

Outcomes