Hi,
I have a program which retrieves value from one resultset and gives it to another is this possible as i am getting an error.
resultset rs1,rs2;
rs1 has a set of distinct elements of one column from the table.
i would like to pass these values to the resultsetstatment of rs2 as a inparamenter which is another sql statment so can i do this way in the sql statement
select x,y from sample where x=getString(element);
element is the values retrived in the first result set and the field name in the database.Is this possible becoz i am getting a error.how can i do this.
Thanks
Lovina
I have a program which retrieves value from one resultset and gives it to another is this possible as i am getting an error.
resultset rs1,rs2;
rs1 has a set of distinct elements of one column from the table.
i would like to pass these values to the resultsetstatment of rs2 as a inparamenter which is another sql statment so can i do this way in the sql statement
select x,y from sample where x=getString(element);
element is the values retrived in the first result set and the field name in the database.Is this possible becoz i am getting a error.how can i do this.
Thanks
Lovina
