I have used the NOT in SQL. the where goes where sno not 'S3' and there is other ways of getting the results.
but instead of discussion at the SQL level what are you trying to accomplish a the entity level. Jonathon -- Improov sent the following on 12/15/2007 4:50 PM: > Oh, yeah, so there is an equivalent in SQL. > > But is there a way to do this in OFBiz? Say "WHERE NOT sno = 'S3'"? > > Using EntityExpr? Note that minilang does not support that "NOT" logical > in <entity-expr> nor <entity-condition> > > Not that we really need this a lot. Any "NOT"ed expression can be > expanded, and the "NOT" removed. > > Jonathon > > BJ Freeman wrote: >> http://www.firstsql.com/tutor2.htm >> and is used for the same function in minilang. >> you can say and expresion is equal then encase it in a Not to make it >> not equal. >> >> Jonathon -- Improov sent the following on 12/15/2007 4:15 PM: >>> I find no usage in OFBiz. Does it even have any equivalent in SQL? >>> >>> Jonathon >>> >>> >>> >> >> > > > >
