how to get first 15 records with customer name,number from t

Posted by ravinandhan on 08-Jan-2015 00:35

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

Posted by Dileep Dasa on 08-Jan-2015 00:44

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

Posted by Dileep Dasa on 08-Jan-2015 01:25

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

Posted by Elsworth Burmeister on 08-Jan-2015 01:32

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


[collapse]
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.

[/collapse]

This thread is closed