Sql Statement with Interaction Form filed value

[Sandy]

Hi Friends,

 

 

I have created the interaction form to assign to the approval. after the appoval is done i want to store he form values to the database. I have created the table and i am using insert into database. in the in line query i have to pass the value for the text box. Please help me how can i active this?

 

I have used insert into SIR (serialno) values ('"+SRNO+"')

I have used insert into SIR (serialno) values ('"+Process.SRNO+"')

I have used insert into SIR (serialno) values ('"+Frm.SRNO+"')

I have used insert into SIR (serialno) values ('"+SRNO.Text+"')

 

 

But it storing the text as Process.SRNO not the value of SRNO.

 

Please help

 

[Rahul Adokar]

Sandy,

From what I understand, I think you're trying to access the IRF output variable to be used in the parent process. If so, then try Process[OpName].SRNO instead. Otherwise, elaborate little more so that we can see some more thoughts coming from this forum.

Hope this helps.
Rahul

[Sandy]

Dear Rahul,

 

Thanks for your reply. Its working with given syntax.  Process[OpName].SRNO.

Can you clarify me on below issue: OpName is current operator name?  there are many operators we used and if i need toread value from the specific operator do i need to give the operator name like Process.[approva].Assignee;

 

Thanks

sandy

[Andrés Jesús Márquez Martín]

Hi,

try this in the pre-execution:

if (Process[OpName].QueryResults != undefined && Process[OpName].QueryResults .length == 0) { 

deleteValueMapField(Process[OpName], "QueryResults"); 

}

2013/4/24 Sandy <veda...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "CA Process Automation Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to itpam-forum...@googlegroups.com.
To post to this group, send email to itpam...@googlegroups.com.
Visit this group at http://groups.google.com/group/itpam-forum?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.