Hi, Would be great if you could let me know how to pass a key in the query while creating a database check point? My key value is stored in a variable in the script.In short, what I want to know is:myVar='keyvalue'select * from myTable where myKey='keyvalue';Instead of specifying the query like select * from myTable where myKey='keyvalue'; in the database checkpoint, I want to use the variable myVar...

sri_yarley

 Profile Answers by sri_yarley Questions by sri_yarley

• Apr 16th, 2008

While a database checkpoint is created, the select statement gets stored in "Source".So for parameterizing it, Create a checkpoint initially in the normal flow with a constant value.....and ...

ManjuPillae

 Profile Answers by ManjuPillae Questions by ManjuPillae

• Mar 26th, 2008

'Assume that 'key' values are present 'keyValues' column under the Local datasheetFor ......    myVar = DataTable("keyValues",dtLocalSheet)&...

Answer Question  Select Best Answer