我們一般在建立一個簡單的Tabular Form的做法如下:
首先我先建立一個View for Query(F11)使用
In general, complex blocks are based on views while simple setup
blocks are based on tables.
透過View來呈現資料是比較簡單的方式:(節錄於Oracle Applications Developer’s Guide)
- 1.Network traffic is minimized because all foreign keys are denormalized on the server
- 2.You do not need to code any POST–QUERY logic to populate non–database fields
3.You do not need to code PRE–QUERY logic to implement query–by–example for non–database fields
[Query Data Souce Name] : View Name
[DML Data Target ]
Column 上的設定
DML Table Column - 要設定一個Primiary Key Column
Non DML Table Column Setting
ps. 此Column 要能夠讓User 從 LOV選擇,並儲存 ID 值到DML table中
注意:如果Column是要Query by view, 但寫入時不寫入DML Table的,其property中”Query Only”要設定成”Yes”(如下圖)
全站熱搜