Home » Developer & Programmer » Forms » Managing data block based on outer join (10)
Managing data block based on outer join [message #352243] Mon, 06 October 2008 15:52 Go to next message
yuriy_l
Messages: 6
Registered: September 2008
Junior Member
Hello All,

I have a form which is used for managing dates of study exams. Data structure is organized as follows: exam ids and names are located in table A, table B includes exam date and foreign key exam_id, referencing particular exam in table A. There are situations, when for an exam there is no date (no record) in table B.

On form I should present all the exams and their dates. Thus, I'm using the outer join B on A.

After unsuccessfull tries it seems to me that in such situation I'll not be able to use standard Forms insert/update/delete mechanism.

Is it so?
I'll appriciate any of Your comments/suggestions.

Yuriy.
Re: Managing data block based on outer join [message #352279 is a reply to message #352243] Mon, 06 October 2008 23:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using a master-detail style of form?

Have you considered using the 'post-query' trigger to populate the 'exam date' and if it does not exist and you add it then use a manual 'insert' statement to add it?

David
Re: Managing data block based on outer join [message #352449 is a reply to message #352279] Tue, 07 October 2008 13:43 Go to previous messageGo to next message
yuriy_l
Messages: 6
Registered: September 2008
Junior Member
As far as I know, in Master-Detail construction corresponding record(s) from the detail table are shown only when focusing on the referenced master table record. So, I can't use this construction - I need to show all the records at once.

But your second suggestion provided me to a solution - if some exams which are going to be shown on form don't have date records in table B - I'm inserting such empty records in autonomous transaction in PRE-QUERY trigger. So, in such case I have always 1 to 1 relationship on the form, and thus Forms could perform all the DML.

Thanks, Yuriy.
Re: Managing data block based on outer join [message #352461 is a reply to message #352449] Tue, 07 October 2008 17:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't understand the meaning of either of the paragraphs in your response, but as long as you have a working solution that's all that matters.

David
Previous Topic: "Enabled" property not working
Next Topic: Blocking alert dialog with more than 3 buttons
Goto Forum:
  


Current Time: Wed Dec 07 10:50:04 CST 2016

Total time taken to generate the page: 0.08343 seconds