Tabular Form fill data from cursor [message #687991] |
Mon, 07 August 2023 02:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3f69abcb86250b3a1da847bc37f5109f?s=64&d=mm&r=g) |
HasnainAli
Messages: 6 Registered: September 2018
|
Junior Member |
|
|
HI,
A.O.A
I want to pull data from database table Employee and show in a block.
I created block manually and when my form open or i pressed a data load button then all record of table employee show in a tabular from.
Basically I am going to create attendance form for employee when my form open all active employee show in tabular form and after that
I select P ,A,L and then pressed save then all record of above saved in database table attendance.
in oracle form builder 6i.
help me please to do this.
|
|
|
Re: Tabular Form fill data from cursor [message #688014 is a reply to message #687991] |
Thu, 10 August 2023 02:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Quote:I created block manually
From my point of view, that - the very first step - was wrong.
If you used data block Wizard, Forms would create a fully functional tabular form where you'd just
- execute query (with possible filters) to fetch existing data
- modify anything you want
- save changes
If you don't want to make it look fancy, you'd have it up & running in a matter of seconds.
Of course, you CAN do it manually, but that requires much more work to fix everything you need. If I were you, I'd delete that form and create a new one, using the Wizard.
|
|
|