Problems deleting records from a query

Article View: borland.public.cppbuilder.database.ado

Article #1697

Back to borland.public.cppbuilder.database.ado Previous Next

#1697

From: Mario Sernicola
Date: Thu, 08 Apr 2004 08:24

24 lines
1554 bytes

Hi,

I've an ADO query with this SQL properrty:

SELECT Table1.*, Table2.Field1
FORM Table1 LEFT JOIN Table2 ON Table1.ID_Table2 = Table2.ID
ORDER BY Data

If I try to delete a record using query's method:

query->Delete(); or
query->DeleteRecords(arCurrent);

I fail with an exception.

(in ITalian)-> "Le informazioni della colonna chiave non sono sufficienti
per l'aggiornamento"

(in English ... I think is...) "The informations about key column aren't
enough for update"

How can I delete a record from my query using methods and not SQL commands?

TNX

Technical Details

Message-ID: <40750c3f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!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-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4a66d2288a2ad0fa,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-04-08 01:39:29 PST
Reply-To: "Mario Sernicola" <mariosernicola.nospam@libero.nospam.it>
From: "Mario Sernicola" <mariosernicola.nospam@libero.nospam.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problems deleting records from a query
Date: Thu, 8 Apr 2004 10:24:41 +0200
Lines: 26
Organization: i'msoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 80.181.137.138
Message-ID: <40750c3f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1081412671 80.181.137.138 (8 Apr 2004 01:24:31 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail