Dont mention it. I solved the problem through code

But now i got into another problem. My problem is that

Application table has child tables which contains the appid and...

YEAH THAT SOLVED THE PROBLEM

THANKS

OK Here it goes

i wrote a script which is actually writing some value in the user defined variable. then i used the post execute method to update result after the...

i didnt exactly understand what u said

can u elaborate it as i am not using any sp here

hello kbatta

the code u sent me is great and it solved my problem

but there is a problem.

when i use the pkval variable as a string and write a sql statement...

select pk_val from pkid where pk_name='Formid'

NO actually not i am using the simple sql statement with one input and one returning value

i did choose the single row

but it wont work

the column name that i want to retrieve and the variable name used

I think you are mistaken

it will give a 0 value rather than null which i dont want

So please suggest something else

just for the information

the variable is typed as ? and then it is selected from the parameter list.

But u said to use them in select statement. But im taking...

thanks for the code.

At the moment i am trying to figure out how to solve the null value problem in the parentformid column as it keeps changing all the time

Hello

can you tell me how would i gonna update the pkid table as the logic behind this is that as the formid value is incremented after that the pkid...

im asking this for some other purpose actually

i just wanted to ask one thing for you

how to use the variables in the execute sql task to retrieve the oracle table records and then do a for...