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
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
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 |
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
Flag this post as spam/abuse.