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.

To populate grid with dynamic view type of record fields in it

2 replies [Last post]
Guest's picture
Guest

Hi Compshack,

I have to populate database record values into a grid ,,,,in which all fields of that grid are of Dynamic view record type.

i have that corresponding database values through SQL and now i need to know where to write this SQL and poeplecode to populate values on grid with dynamic view record fields,,

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: To populate grid with dynamic view type of record fields ...

If you have SQL then why cannot doing a ScrollSelect?

Cheers
Nitin

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: To populate grid with dynamic view type of record fields ...

How about using "Select" or SelectNew" rowset methods?

Local rowset &myrowset;

&myrowset = CreateRowset(Record.Record-example);
&myrowset.flush();
&myrowset.Select(Record.Record_selecting_from, "Where field1 = :1 and field2 = :2", &field1, &field2);

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog