|
|
Re: how to display table column heading on oracle form 6i [message #586706 is a reply to message #586648] |
Mon, 10 June 2013 04:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/71e7ed14bc76446bef38666d8e833174?s=64&d=mm&r=g) |
sameer_da
Messages: 74 Registered: April 2013 Location: India
|
Member |
|
|
ok i am able to display the headers on the form with help of master detail relationship.
but now i want to store these values in different variables. i.e
suppose in my forms I've display 5 records and the design time view is somewhat like this
column
---------------------
ex
ex
ex
ex
ex
and when i run the form the display is some what like this
column
---------------------------
ok
tally
oracle
sql
plsql
vb
now i want to store these values i.e (ok, tally, oracle, sql, plsql, vb) in the separate variables like v1, v2, v3, v4, v5
How can i achieve this.
Thank you.
|
|
|
Re: how to display table column heading on oracle form 6i [message #586707 is a reply to message #586706] |
Mon, 10 June 2013 04:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
What is the purpose of what you are trying to do? Such a design isn't very promising, because it will be OK when there are 5 records there (so yes, you can create 5 variables (v1, v2, ..., v5) and store item values into these variables). What will you do when query returns 100 records? 10000 records? Create that many variables?
Therefore, if you could explain what is the purpose of that form, perhaps someone will suggest another, better approach.
(As of your question: loop through all records in a block and store values into variables).
[Updated on: Mon, 10 June 2013 04:31] Report message to a moderator
|
|
|
|
|
|
Re: how to display table column heading on oracle form 6i [message #586722 is a reply to message #586717] |
Mon, 10 June 2013 05:44 ![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: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Huh, I believe you are. I'm talking nonsense, sorry. These aren't single items as they belong to different records so yes - variables are one way to do that. Another option (probably simpler to maintain) is to create a record (array, collection) and pass that to another procedure. You'll still have to loop through all block records to do that.
|
|
|