Re: persistent.delete() ?

Hi Mike.

Do you know a good doctor for reattaching feet that have been shot off 
by one's own action?  I did not think about using a query service for 
the deletes, and I should have.

OTOH, maybe the default DataStore's can be readily upgraded to handle a 
"Single Row Delete"?  I would be happy to tackle that one, if it would 
be a good idea.

Regards,
Steve

Michael Nash wrote:

>Steve:
>
>  
>
>>I do object to the Database overhead that your suggestion would entail.
>>    
>>
>
>If there are many deletes then yes, this would be a lower performance
>approach. 
>
>One problem though is the "and" nature of the query: e.g. if you say:
>
>p.setField("oneField", value);
>p.setField("oneField", value2);
>
>and then do (for example) a query, you get just oneField=value2, not
>value OR value2... 
>
>So it should be possible to steal some code from Query to build the
>where clause for a delete, but you still can't do an "or" without
>multiple calls.
>
>The Query service, OTOH, can do this right now, as you can supply any
>arbitrary SQL, including deletes as complex as you like.
>
>Mike
>
>  
>


-- 
Java/J2EE Developer/Integrator
Stephen Davidson and Associates, Inc.
Chair, Dallas/FortWorth J2EE Sig
214-724-7741