On Sep 18, 2006, at 3:31 PM, Jonathan Vanasco wrote:

>       a.1.b.1.FIELD = a.2.a.1.a.FIELD
>
> rose doesn't seem to support this outright
>
> anyone have a clue how i can coerce this?

Sorry, I forgot to add that this is within a nested conditonal

WHERE
        (
                a.1.b.1.FIELD_1 IN ( 1,2,3 )
                OR
                (
                        a.1.b.1.FIELD_1 IN ( 3,4,5)
                        AND
                        a.1.b.1.FIELD_2 = a.2.a.1.a. FIELD_2
                )
        )

which negates use the 'clauses' construct, unless I write the entire  
where

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to