Adding new detail Records on Update

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

Article #154

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

#154

From: Adrian Mercieca
Date: Mon, 11 Feb 2008 10:00

16 lines
1524 bytes

Hi,

I have a master/detail relationship between 2 queries in a datasnap 
application.

Is it possible to insert new records into the detail when a new record 
has been inserted into the master, before the whole data is committed to 
the DB? I'd like to be able to do this on the server side.

I know that I should be doing this on the OnUpdateData or 
OnBeforeUpdateRecord of the export dataset provider on the server, but 
what is the exact syntax to use? When I tried adding new records to the 
detail data packet, I kept getting an 'operation not supported' 
exception of some sort.

Tks - Adrian.

Technical Details

Message-ID: <47b01cc1$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fcd2b,243d4d354decb165,start
X-Google-Attributes: gidfcd2b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 11 Feb 2008 11:00:31 +0100
From: Adrian Mercieca <amercieca@gmail.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Adding new detail Records on Update
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 195.158.111.182
Message-ID: <47b01cc1$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1202724033 195.158.111.182 (11 Feb 2008 02:00:33 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail