hi,
can any body please reply for this one

Hi,

I have solved this issue, using sqlexec, which is not a genuine solution . If any body knows , how to do it without sqlexec(), then plzzz leme know ..thanks,

how can we fecth by using sqlexe ...
it will fetch data from data buffer
not from component buffer
...
i.e if i deleted one row in add mode...
actually the row is flaged in component buffer....
my requirement is how to know those flaged row....
before saving to the data base...

well, thats true . with sqlexec() ,It will not fetch data from component buffer.
my req. waswateer i addd in my second scroll which is at level 1. on save , add those values in scroll one which is also at level 1. which I am able to by comparing my one value of 2nd scroll and then getting d correspondig value.. I am using sqlexec() in loop and in loop i m using insertrow() function.

hi,

thanks for ur reply..

some function are there to fetch data from component buffer..
Isdeleted....
is new...
these are properties used to chek weather the row is new or is deleated...
i used these tow functions for my requirement

Did you use RowSet, Row and Record classes?

Sample code to copy the entire rowset would be,

Local RowSet &rs0, &rs1, &rs1_;

&rs0 = GetLevel0();
&rs1 = &rs0(1).GetRowSet(Scroll.Level1_ScrollA_Record);

&rs1_ = &rs0(1).GetRowSet(Scroll.Level1_ScrollB_Record);

&rs1.CopyTo(&rs1_ , Record.Record1_Source, Record.Record1_Target);

Hi,
Thanks alot for your help.It worked now .

Thanks,
Deepika