Writing back ClientDatasets, build from multiple, nested tables

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

Article #974

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

#974

From: 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--

Technical Details

Message-ID: <397D5C92.46F727E1@synotec.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,d73146630c660785,start
X-Google-Attributes: gidfcd2b,public
From: Michael Hüls <Michael.Huels@synotec.com>
Subject: Writing back ClientDatasets, build from multiple, nested tables
Date: 2000/07/25
Message-ID: <397D5C92.46F727E1@synotec.com>
X-Deja-AN: 650477707
X-Accept-Language: en
Content-Type: multipart/alternative; boundary="------------357B964BBAE5543609DFEDEA"
X-Trace: 25 Jul 2000 02:11:32 -0800, 194.231.83.144
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier