Nelson Chui
Guest
|
 Posted: Mon Oct 27, 2003 10:57 am Post subject: Update CDSDetail with joined fields from some large Master t |
 |
|
Hi,
I don't know how can I insert / update / delete a Detail CDS ( some
field is joined from other large master tables ).
Simplified my case :-
Header's Data fields := MEMO_NO, MEMO_DATE, CUSTOMER_CODE.
Detail's Data fields := MEMO_NO, TX_SEQ.
TDataSet of Detail's SQL :-
SELECT
D.MEMO_NO, D.TX_SEQ, L.STOCK_CODE, M.STOCK_NAME
FROM
T_DETAIL D
LEFT JOIN T_LEDGER L ON D.TX_SEQ = L.TX_SEQ
LEFT JOIN T_STOCK M ON L.STOCK_CODE = M.STOCK_CODE
WHERE
D.MEMO_NO = :MEMO_NO
When CDSHeader is called ApplyUpdates, the SQL Monitor is only shown
[Prepare] TDataSet of Detail for query SELECT and there is only Insert /
Update / Delete done on TDataSet of Header.
I also try to attach TIBUpdateSQL to TDataSet of Detail with proper
insert/update/delete SQL statements, but there is nothing to use after
CDSHeader's ApplyUpdates.
If the Detail's Data fields is on its own field MEMO_NO, TX_SEQ, the
CDSDetail is done correctly.
Would you give me some advice ?
Regards,
Nelson.
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
