You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to fetch data from compoent buffer

7 replies [Last post]
deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26

Hi,

Can any body tell me , how to fetch data from buffer.
I fetched 4 fields on a scroll which is at level 1.
among them 2 fields are from Record 1 and 2 fields are from Record2.

and Record1.field2 is a prompt which is display control field.
and record2. field1 and field2 are related fields..which are showing the related values..

Now , I need to fetch all these four values and put in another scroll , which is also at level1.

can any body give me some clue or code about it.

anithan's picture
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: How to fetch data from compoent buffer

hi,
can any body please reply for this one

deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26
Re: How to fetch data from compoent buffer

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,

anithan's picture
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: How to fetch data from compoent buffer

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...

deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26
Re: How to fetch data from compoent buffer

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.

anithan's picture
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: How to fetch data from compoent buffer

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

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: How to fetch data from compoent buffer

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);

deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26
Re: How to fetch data from compoent buffer

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

Thanks,
Deepika