Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 76101 invoked from network); 20 Oct 2010 17:58:35 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 Oct 2010 17:58:35 -0000 Received: (qmail 66441 invoked by uid 500); 20 Oct 2010 17:58:35 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 66395 invoked by uid 500); 20 Oct 2010 17:58:34 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Delivered-To: moderator for user@cayenne.apache.org Received: (qmail 59725 invoked by uid 99); 20 Oct 2010 17:56:34 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Message-ID: <44873.95.93.134.16.1287597365.squirrel@webmail.holos.pt> In-Reply-To: References: <4DCF04C5-D7EA-419B-A09A-1478ACA96C9A@objectstyle.org> <000601cb6ff2$da183760$8e48a620$@pt> <8208A2AE-9E1B-4CDC-AA81-6A2C93ED051D@objectstyle.org> <000f01cb703f$85c6a5f0$9153f1d0$@pt> Date: Wed, 20 Oct 2010 18:56:05 +0100 (WEST) Subject: Raw delete From: brd@lamp1.dmz.holos.pt To: user@cayenne.apache.org User-Agent: SquirrelMail/1.4.13 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-15 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Checked: Checked by ClamAV on apache.org Hello all, Whats the better way to do a regular delete from in raw sql? I tried a raw sql named query on the modeler but i get a Null PK error, maybe because no data rows are returned? Thank you