๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

RE: Error: 'Capability not supported'

#215
From: Juan Pablo Lecocq
Date: Wed, 05 Jul 2000 00:00
44 lines
2499 bytes
I Think it's simple Table does not have primary key and no edit or update
can be made
due to DBE can't find the record after edit or update.


Alan Lorbada <alorbada@teleline.es> escribi๏ฟฝ en el mensaje de noticias
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: <396362be_2@news.arrakis.es>
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
X-Google-Thread: ffff5,26b4b7a725d83b02
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10baee,26b4b7a725d83b02
X-Google-Attributes: gid10baee,public
X-Google-Thread: 109585,26b4b7a725d83b02
X-Google-Attributes: gid109585,public
From: "Juan Pablo Lecocq" <jlecocq@arrakis.es>
Subject: RE: Error: 'Capability not supported'
Date: 2000/07/05
Message-ID: <396362be_2@news.arrakis.es>
X-Deja-AN: 642706179
References: <2qj85.19073$Bg2.92942@telenews.teleline.es>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Trace: 5 Jul 2000 18:30:54 +0100, 212.59.206.163
Organization: Arrakis Servicios y Comunicaciones SLU
X-MSMail-Priority: Normal
Reply-To: "Juan Pablo Lecocq" <jlecocq@arrakis.es>
Newsgroups: comp.lang.pascal.delphi.databases,comp.lang.pascal.delphi.misc,es.comp.lenguajes.delphi