How to order table ABC based on the fields in table XYZ [message #137697] |
Fri, 16 September 2005 02:50 |
corus
Messages: 12 Registered: July 2005 Location: Process Control
|
Junior Member |
|
|
Please could someone suggest how I can order table ABC based on the fields in table XYZ.
I need to do it in Forms with table ABC, so I cannot simply use a view which combines the two tables.
The two tables are linked thus:- ABC.id = XYZ.id
(It is a one to many relationship, but I am using a MIN function in XYZ.)
The desired order of 'id' is directly available (via several fields) in the XYZ table, but I want to effectively apply this order to the ABC table.
Your help on this problem would be much appreciated.
|
|
|
|
Re: How to order table ABC based on the fields in table XYZ [message #137985 is a reply to message #137911] |
Mon, 19 September 2005 05:00 |
corus
Messages: 12 Registered: July 2005 Location: Process Control
|
Junior Member |
|
|
I have got a form with a table, view and another table, which are all linked. The second table has a date of when actions need to be completed.
When the user wants to see their actions I need the order to be by the action date.
For general use the order is just based on the first table.
With our version of oracle we cannot update a view.
Thanks,
Michael
|
|
|
|
|
Re: How to order table ABC based on the fields in table XYZ [message #138234 is a reply to message #138117] |
Tue, 20 September 2005 17:44 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Okay ... Oracle 8i WILL do updatable views. Make sure that there are no group statements, no union statements, and that ALL the columns associated with the various primary keys exist in the the selected columns.
If you have problems, then post the table definitions and the view you are trying to create.
Look at 'user_updatable_columns' for your user and view and check whether the columns in which you are interested are updatable.
David
[Updated on: Wed, 21 September 2005 23:48] Report message to a moderator
|
|
|