Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

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

  • Post reply
2 replies [Last post]
Thu, 04/23/2009 - 1:56am
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,,

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
Tue, 04/28/2009 - 2:48am
#1
Nitin's picture
Nitin
User offline. Last seen 39 weeks 4 days ago. Offline
Joined: 06/30/2008
Posts: 58
Re: To populate grid with dynamic view type of record fields ...

If you have SQL then why cannot doing a ScrollSelect?

Cheers
Nitin

Top
  • reply
Tue, 04/28/2009 - 6:26am
#2
Lepa's picture
Lepa
User offline. Last seen 6 days 7 hours ago. Offline
Joined: 06/23/2008
Posts: 570
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

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.