🚀 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 Michael Hüls Tue, 25 Jul 2000 00:00
Writing back ClientDatasets, build from multiple, nested tables
#974
Author: Michael Hüls
Date: Tue, 25 Jul 2000 00:00
79 lines
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>&nbsp;</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