Home » Developer & Programmer » Forms » How do I sort a non database table column in a block ???
How do I sort a non database table column in a block ??? [message #190235] Tue, 29 August 2006 18:17 Go to next message
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

Re: How do I sort a non database table column in a block ??? [message #191743 is a reply to message #190235] Fri, 08 September 2006 00:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Have you tried using a 'view'? This would save having to do the Post-Query and would enable you to sort by 'FNAME' and 'LNAME'.

David
Re: How do I sort a non database table column in a block ??? [message #192376 is a reply to message #191743] Tue, 12 September 2006 01:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Via PM from gs77 on Tue, 12 September 2006 10:55

Yes. I solved the problem. See at
http://www.oracle.com/technology/products/forms/pdf/BlockOnAJoin.pdf

Thanks.
G
Previous Topic: Help me!! file information
Next Topic: 2 small problems in oracle forms
Goto Forum:
  


Current Time: Wed Dec 07 12:21:36 CST 2016

Total time taken to generate the page: 0.12963 seconds