select from database operator (Sql statement with where clause)

[Sandy]

  Hi Friends,

 

I am using the  select from database operator to run the Sql query to select the result. With normal Sql query its working fine with me but can any one tried Sql quet with where clause?

 

I am using Input source Expression and in the pre eeecution i write query.

 

I tried with where column_name = Process.valriable its not giving the reqult.

 

Is their any sysntax for using the variable in where condition?

 

 

 

 

Thanks

 

sandy

[Santosh Suryawanshi]

Hi ,

 

Find the way.

 

where columnnam = '"+process.variable+"'

--
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.
For more options, visit https://groups.google.com/groups/opt_out.