Thread View: borland.public.cppbuilder.database.multi-tier
1 messages
1 total messages
Started by Michael Hüls
Tue, 25 Jul 2000 00:00
Writing back ClientDatasets, build from multiple, nested tables
Author: Michael Hüls
Date: Tue, 25 Jul 2000 00:00
Date: Tue, 25 Jul 2000 00:00
79 lines
4064 bytes
4064 bytes
--------------357B964BBAE5543609DFEDEA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi there I want to create a multi tiered CppBuilder application to edit data, stored in multiple, nested tables (MS-SQL-Server or ORACLE database). I use CORBA (VisiBroker) and MIDAS for Client-Server-Communication. When I provide my ClientDataset with data from an appropriate SQL statement on the server, it works fine for data display, even for local edit (edit on the ClientDataset), but I can't write the changed data back to the database. May be, because the data has to be written into different tables. Question 1 : What are the appropriate concepts to cover my requirements and what kind of components or methods do I have to apply ? Question 2 : When I do local edit (edit on the ClientDataset), I might get inconsistent data within the ClientDataset (and the associated displays), because the ClientDataset does not know about the dependencies between the different nested tables. How can I avoid this or what kind of components or methods do I have to apply to cover this. Can anybody out there give me a helping hand ? Thanks Michael --------------357B964BBAE5543609DFEDEA Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <font face="Arial,Helvetica">Hi there</font><font face="Arial,Helvetica"></font> <p><font face="Arial,Helvetica">I want to create a multi tiered CppBuilder application to edit data,</font> <br><font face="Arial,Helvetica">stored in multiple, nested tables (MS-SQL-Server or ORACLE database).</font> <br><font face="Arial,Helvetica">I use CORBA (VisiBroker) and MIDAS for Client-Server-Communication.</font> <p><font face="Arial,Helvetica">When I provide my ClientDataset with data from an appropriate SQL statement on the</font> <br><font face="Arial,Helvetica">server, it works fine for data display, even for local edit (edit on the ClientDataset),</font> <br><font face="Arial,Helvetica">but I can't write the changed data back to the database.</font> <br><font face="Arial,Helvetica">May be, because the data has to be written into different tables.</font> <br><font face="Arial,Helvetica">Question 1 :</font> <br><font face="Arial,Helvetica">What are the appropriate concepts to cover my requirements and what kind of</font> <br><font face="Arial,Helvetica">components or methods do I have to apply ?</font> <br><font face="Arial,Helvetica">Question 2 :</font> <br><font face="Arial,Helvetica">When I do local edit (edit on the ClientDataset), I might get inconsistent data within</font> <br><font face="Arial,Helvetica">the ClientDataset (and the associated displays), because the ClientDataset does not know</font> <br><font face="Arial,Helvetica">about the dependencies between the different nested tables.</font> <br><font face="Arial,Helvetica">How can I avoid this or what kind of components or methods do I have to apply to cover this.</font><font face="Arial,Helvetica"></font> <p><font face="Arial,Helvetica">Can anybody out there give me a helping hand ?</font><font face="Arial,Helvetica"></font> <p><font face="Arial,Helvetica">Thanks</font><font face="Arial,Helvetica"></font> <p><font face="Arial,Helvetica">Michael</font> <br><font face="Arial,Helvetica"></font> </html> --------------357B964BBAE5543609DFEDEA--
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