Will the three-tier structure, if you want to manipulate database records, is each time with rewriting ClientDataset.CommandText: = 'Sql', or use ClientDataSet1.ApplyUpdates method is better? What is the difference between what? Thank you

Category: Delphi -> Database Author: keqingrong Date: 2004-07-22 11:38:35
 
keqingrong
2004-07-22 11:38:35
Will the three-tier structure, if you want to manipulate database records, is each time with rewriting ClientDataset.CommandText: = 'Sql', or use ClientDataSet1.ApplyUpdates method is better? What is the difference between what? Thank
hmajia
2004-07-22 11:53:04
general use ClientDataSet1.ApplyUpdates method, which can realize batch submission, and data packets transmitted through the compression, the better solution of three-tier structure would solve a problem: the network transmission bottlenecks. Also allows the server program (business rules layer) have the opportunity to conduct special handling of data, which is the recommended approach.
try not to change the data in the client program using ClientDataset.CommandText change, contrary to the use of three-tier architecture design ideas, not as direct use of c / s-style, in addition to the amount of additional programming.
bearbit
2004-07-22 11:55:44
You do not understand the purpose of ~ _ ~
qimu109
2004-07-22 12:09:28
suggest you go take a look at Levi's "Delphi5.x distributed multi-tier application system." There are detailed data about the three-tier structure
refresh example.
xiaoxiangyu12345
2004-07-22 12:23:53
write your own interface functions to submit SQL statements it