|
|
|
|
| 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   |
 |
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 |
 |
Littlefoot
Messages: 21808
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 |
|
Littlefoot
Messages: 21808
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
