Form Master - Detail - PowerPoint PPT Presentation

1 / 15
About This Presentation
Title:

Form Master - Detail

Description:

Title: Slide 1 Author: Vivine Last modified by: Vivine Created Date: 5/30/2006 8:08:36 AM Document presentation format: On-screen Show Company: STIKOM – PowerPoint PPT presentation

Number of Views:33
Avg rating:3.0/5.0
Slides: 16
Provided by: Vivi1150
Category:

less

Transcript and Presenter's Notes

Title: Form Master - Detail


1
Form Master - Detail
2
Langkah langkah pembuatan
3
next
4
next
5
next
6
next
7
next
8
next
9
next
10
Tampilan block master dan detail
11
Object Navigator
12
Relations
13
Delete Record Behavior
  • Non Isolated
  • Tidak diijinkan menghapus record master bila
    terdapat record detail (On-Delete-Master Trigger)
  • Cascading
  • Menghapus record detail bila master dihapus
    (Pre-Delete-Trigger)
  • Isolated
  • Hanya menghapus record master

14
Perubahan relasi antara master dan detail
  1. Perubahan dari non-isolated menjadi cascading
    akan mengganti On-Delete-Master Trigger dengan
    Pre-Delete
  2. Perubahan dari non-isolated menjadi isolated akan
    menghapus trigger On-Delete-Master

15
Coordination
  • Default
  • Deferred no , Automatic Query yes
  • Deferred with Auto Query
  • Deferred yes , Automatic Query yes
  • Query dilakukan setelah kursor menuju block
    detail
  • Deferred without Auto Query
  • Deferred no , Automatic Query no
  • Dapat menggunakan kriteria query tambahan untuk
    block detail
  • Prevent Masterless Operation
  • Prevent Masterless Operations yes
  • Detail tidak dapat di-query atau insert, jika
    record master tidak ada
Write a Comment
User Comments (0)
About PowerShow.com