| How to list records in form [message #549029] |
Tue, 27 March 2012 10:59  |
maggy_ashee
Messages: 70
Registered: May 2007
|
Member |
|
|
Hi Guys,
I got to list some records in Oracle form (with scroll bar, something like reports). Please advice.
Output should be as below.
Order Number date status name end_date
123 23-jan-2001 approved sam 25-jan-2001
253 28-jan-2002 approved pam 30-jan-2002
213 29-jan-2001 approved kam 30-jan-2001
.
.
.
.
.
Thx
|
|
|
|
|
|
|
|
|
|
| Re: How to list records in form [message #549047 is a reply to message #549029] |
Tue, 27 March 2012 12:48  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
maggy_ashee wrote on Tue, 27 March 2012 11:59Hi Guys,
I got to list some records in Oracle form
Define "some." But in any case you need to do what cookiemonster and Littlefoot suggest.
|
|
|
|
| Re: How to list records in form [message #549162 is a reply to message #549029] |
Wed, 28 March 2012 06:56 |
maggy_ashee
Messages: 70
Registered: May 2007
|
Member |
|
|
Hi Guys,
Thanks for your inputs!
I have created a data block with tabular layout. I have multiple records to be returned. I tried using select, it failed saying exact fetch returns more than one row. Should I write a cursor and loop it or is there any setup in Property pallete which can list multiple records. Please advice.
|
|
|
|
| Re: How to list records in form [message #549181 is a reply to message #549162] |
Wed, 28 March 2012 07:37 |
cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Again - what's wrong with the default query functionality?
If you don't know how it works read up on it in form builder help. Start with the topics on query processing and execute_query.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
