| How do I sort a non database table column in a block ??? [message #190235] |
Tue, 29 August 2006 18:17  |
gs77
Messages: 7
Registered: August 2006
|
Junior Member |
|
|
Hi,
I have an issue. I have master a detail block. In detail block, I have following columns:
FNAME (non database column, 1st col in canvas)
LNAME (non database column, 2nd col in canvas)
SSN (database column, 3rd col in canvas)
Number of Books (database column, 4th col……)
…………………
Fname and Lname are populated from other table thru Post-Query
on query. Fname, Lname can be entered manually or thru LOV and populate SSN (and vice versa). SSN is P/K. Number of Books is
updateable field.
The detail block does not have any sort order. But I would like
to sort with Fname, Lname. I don’t know how I will do that as
Fname and Lname are not database columns.
Any help will be really appreciated. The version of the forms
is 6i.
Thanks.
[Updated on: Tue, 29 August 2006 18:19] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
