Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Joined Delete
Date: Thu, 10 Apr 2008 08:30:08 -0700
Message-ID: <C27EE712DBADE14286DA449499F17F8794F090@ABmail.activx.com>
In-Reply-To: 
 <OF4EFE73ED.586962D7-ONC1257427.0029204A-C1257427.00297100@seitenbau.net>
Thread-Topic: Joined Delete
thread-index: Acia3SFB1lAmn3PTTyOKJRcooZ+NHAAQgtzg
From: "Manaster, Carl" <CarlM@ACTIVX.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

Hi, Thomas,

Thank you for the reply.

> - A criteria can be changed when a select is made. You use=20
> the same criteria to count and to delete. This is typically=20
> not a good idea.

That comes as a surprise to me - I would not expect use of a criteria to
change it.  I tried it just now with separate but (initially) identical
criteria and the behavior is unchanged.

> - Unfortunately, select and delete sql is composed=20
> differently. Have you tried to debug the sql code which is=20
> used for the delete ?

No, I haven't.  As I dug into it, when it got to BasePeer, it hit
library code (classes from the jar instead of source files in my
project) before creating the sql and I haven't yet brought the torque
source into my project to debug further.

Peace,
--Carl

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org