🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.cppbuilder.database.multi-tier
1 messages
1 total messages Started by Li Xiangyang Tue, 21 Dec 1999 00:00
!!!Muti-tier cachupdate and master/detail problem
#1245
Author: 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!
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads