how to get first 15 records with customer name,number from the table if there are 200 records in Progress OpenEdge database - Forum - OpenEdge Development - Progress Community

how to get first 15 records with customer name,number from the table if there are 200 records in Progress OpenEdge database

 Forum

how to get first 15 records with customer name,number from the table if there are 200 records in Progress OpenEdge database

This question is not answered
define variable i as integer no-undo.
define frame a with 10 down.

for each customer no-lock break by name:
  i = i + 1.
  display i custNum name discount.
  if i >= 5 then leave.
end.

define query q for customer scrolling.

open query q for each customer no-lock break by name max-rows 5.

do i = 1 to 5 with frame a:
  get next q.
  display i custNum name discount.
end.


I am trying to retrieve a records from database ,how can i get in order to fetch records from customer table.

in table level without scoping

can any one help me with sample code

All Replies
  • Can you please show the code you tried? Also, can you please elaborate on what "without scoping" mean?

  • Thanks for editing your question to add code. I don't see any problem with the code you posted. Are you seeing any errors? If yes, please post them

  • Another option might be to use a dataset and set its batch-size to number of records you require?
     
     
     

    Elsworth Burmeister

    Developer - Managed Services

    Cell: +27 83 777 3072 Email: eburmeister@elcb.co.za

     

    ELCB Information Services (Pty) Ltd

    Customer Service Email  elcb@elcb.co.za · www.elcb.co.za

    E A S T  L O N D O N

    Tel: +27(43)  704 0700

    Fax: +27(43) 704 0701

    J O H A N N E S B U R G

    Tel: +27(11) 879 6179

    Fax: +27(11) 454 0384

    P O R T  E L I Z A B E T H

    Tel: +27(41) 373 0529

    Fax: +27(86) 650 0135

    Disclaimer


    From: Dileep Dasa [mailto:bounce-ddasa@community.progress.com]
    Sent: 08 January 2015 09:26 AM
    To: TU.OE.Development@community.progress.com
    Subject: RE: [Technical Users - OE Development] how to get first 15 records with customer name,number from the table if there are 200 records in Progress OpenEdge database
     
    Reply by Dileep Dasa

    Thanks for editing your question to add code. I don't see any problem with the code you posted. Are you seeing any errors? If yes, please post them

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.