Using cached updates and UpdateSQL on server

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

Article #1660

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

#1660

From: Alex
Date: Sun, 18 Jul 1999 00:00

11 lines
987 bytes

I use view as source of data on server side. I need use UpdateSQL for
applying updates to tables. View is connected with TDatasetProvider, which
is exposed for clients using.
When I don't use cached updates with my view, UpdateSQL doesn't work. As I
see on SQL Monitor, BDE tries to apply updates into my read only view and
fails, of cause.
When I use cached updates, it always adds only first record in cache. How
can I manage to apply my updates when I use chaging data through Dataset and
UpdateSQL.

Alex

Technical Details

Message-ID: <7mspv8$d341@forums.borland.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,8b8dfd1fdc39789b,start
X-Google-Attributes: gidfcd2b,public
From: "Alex" <alex740@mail.ru>
Subject: Using cached updates and UpdateSQL on server
Date: 1999/07/18
Message-ID: <7mspv8$d341@forums.borland.com>
X-Deja-AN: 502391543
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.cppbuilder.database.multi-tier