🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.pascal.delphi.databases
Article #217

Re: Error: 'Capability not supported'

#217
From: M.H. Avegaart
Date: Tue, 04 Jul 2000 00:00
43 lines
2507 bytes
Database.ApplyUpdates([Table1, Table2]) with do the StartTransaction and
Commit/Rollback for you.


"Alan Lorbada" <alorbada@teleline.es> schreef in bericht
news:2qj85.19073$Bg2.92942@telenews.teleline.es...
>     Hello everybody! :-)
>
>     Well, I think this is my last recourse, I've tried with everything
> imaginable but nothing... :(
>
>     I'm working with Delphi 4 Client Server and Personal Oracle 8.0.
>     I have two Querys (or Tables, I have tried with both of them), linked
by
> a Master-Detail relation (or not linked, it doesn't care), and I'm working
> in cache with the property CahedUpdates=True.
>
>     The Append or Insert operation works well, using transactions and the
> Commit Operation over the DataBase and the individual querys (to ensure
the
> correct update, although I have tried with only one way separately as
well).
>
>     The problem comes with the Edit operation. Everytime I try to Commit
the
> DataBase or ApplyUpdates to the querys, appears the error 'Capability not
> Supported', and it avoids me from make a correct update.
>
>     And that's all. I have changed the querys for tables, worked with them
> linked o not linked, and the only method to get the Edit operation is
> working without cache and with simples Post. The problem is that I need to
> change several records in a table in the same transaction and using cache.
>
>     Can anybody help me, please?
>
>     Thank you very much in advance. :-)
>
>     Sayoonara! :-)
>
>     Alan Lorbada
>     alorbada@teleline.es
>
>
Technical Details
Message-ID: <8jsgqu$gsh$1@porthos.nl.uu.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <2qj85.19073$Bg2.92942@telenews.teleline.es>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,26b4b7a725d83b02
X-Google-Attributes: gidffff5,public
X-Google-Thread: 109585,26b4b7a725d83b02
X-Google-Attributes: gid109585,public
X-Google-Thread: 10baee,26b4b7a725d83b02
X-Google-Attributes: gid10baee,public
From: "M.H. Avegaart" <avegaart@NOSPAMmccomm.nl>
Subject: Re: Error: 'Capability not supported'
Date: 2000/07/04
Message-ID: <8jsgqu$gsh$1@porthos.nl.uu.net>
X-Deja-AN: 642196636
References: <2qj85.19073$Bg2.92942@telenews.teleline.es>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@nl.uu.net
X-Trace: porthos.nl.uu.net 962709150 17297 193.67.87.80 (4 Jul 2000 11:12:30 GMT)
Organization: UUNET-NL (http://www.nl.uu.net)
X-MSMail-Priority: Normal
NNTP-Posting-Date: 4 Jul 2000 11:12:30 GMT
Newsgroups: comp.lang.pascal.delphi.databases,comp.lang.pascal.delphi.misc,es.comp.lenguajes.delphi