| datagrid in forms 6i [message #439564] |
Mon, 18 January 2010 07:25  |
yasser_egypt2000
Messages: 6
Registered: December 2009
|
Junior Member |
|
|
Dear sirs, please help me
i want to do datagrid or spreadtable in forms 6i for example i want to have list of all the tables in scema and then when i choose the table soon the datagrid control show the field and data of this table which i already select from list
pls anybody help me i did not find any material talk about that in details
best regards for all members
Yasser
|
|
|
|
| Re: datagrid in forms 6i [message #439566 is a reply to message #439564] |
Mon, 18 January 2010 07:34  |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
So you want to pick a table and then just display all the data from that? All columns? All rows?
Do you want to be able to modify the data?
Do you want to be able to restrict the data?
|
|
|
|
| Re: datagrid in forms 6i [message #439597 is a reply to message #439566] |
Mon, 18 January 2010 10:03 |
yasser_egypt2000
Messages: 6
Registered: December 2009
|
Junior Member |
|
|
Dear sir
yes i want to pick table from list of scema tables and show the data on grid
no i do not want to update, but i want to print these data which inside the table
waiting your answer and thank you for your kindly reply
Yasser
|
|
|
|
|
|
|
|
| Re: datagrid in forms 6i [message #439645 is a reply to message #439564] |
Mon, 18 January 2010 22:04 |
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
|
Senior Member |
|
|
U can use third party tools like toad...
Also u can design a dynamic form.U have to polpulate all table
from dba_all_tables for your current user in a Hierarchical tree of Htree item. Then u can pupulate selected table data into a form by when-tree-node-activated trigger.
I think your purpose will be solve by this way.but best solution is TOAD. http://www.quest.com/toad/
|
|
|
|
| Re: datagrid in forms 6i [message #439672 is a reply to message #439645] |
Tue, 19 January 2010 00:59 |
yasser_egypt2000
Messages: 6
Registered: December 2009
|
Junior Member |
|
|
dear sirs, I can not use tools because i should do it in form and then the user will use this form to show his tables from list then data inside every table will be shown in datagrid then he can press button to print it
thanks anyhow
yasser
|
|
|
|
|
|
| Re: datagrid in forms 6i [message #439693 is a reply to message #439672] |
Tue, 19 January 2010 02:02 |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
That's unusual. How do you plan to print it? A printscreen? Might be OK if there aren't many records. What if there are hundreds of records within the table? [Scroll-down and printscreen] x many_times? I don't think so.
Basically, what you are saying is that you'd have SELECT * FROM some_table. In order to create a form, you have to use items. Each of them has its own datatype. It can not be modified during runtime (i.e. you have to create it withing the Forms Builder). So - how will you know which item represents which column? How will you adjust datatypes? Put everything into a character item? How large will they be? Item size can not be modified either. If there are many columns within the table, how will you show them all in a readable manner?
I think I could go on and on, but - I hope you got the point: Oracle Forms is not a tool for that. If you want to print data, use a reporting tool (such as Oracle Reports). If you want to manipulate with data, use Forms.
Perhaps you could do what you've imagined, but it would take too much effort and the result would still be suboptimal.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
