!!!Muti-tier cachupdate and master/detail problem

Article View: borland.public.cppbuilder.database.multi-tier

Article #1245

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1245

From: Li Xiangyang
Date: Tue, 21 Dec 1999 00:00

17 lines
999 bytes

Because the master data is selected from multi tables, so we must use
cachupdate to commit to the database server: We set one TUpdateSQl for each
query in App server,and from client side, after ApplyUpdates,call an
appserver's
method to start a transaction as following:

 DataBase1->StartTransaciton();
 master->ApplyUpdates();
 detail1->ApplyUpdates();
 detail2->ApplyUpdates();
 ...
 DataBase1->Commit();
...
But only the master records go into the database server.

What is the correct method for my job
Thanks in advance!

Technical Details

Message-ID: <83nvpn$gan6@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,f9dcd814cebe7293,start
X-Google-Attributes: gidfcd2b,public
From: "Li Xiangyang" <zheaat@pub.zhuhai.gd.cn>
Subject: !!!Muti-tier cachupdate and master/detail problem
Date: 1999/12/21
Message-ID: <83nvpn$gan6@forums.borland.com>
X-Deja-AN: 563391871
Organization: eaat
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.cppbuilder.database.multi-tier