Hello. I'm constructin a highly dynamic OQL query string. In some specific cases I must include certain clauses...but this clauses are absent in other specific cases. To avoid extremly complicated if / then /else I concluded that it would be easier to use a "true" value in the query string:
query = "select from CLASS" + "where (true and" if (certain case) then query += "variable < x"; if (certain case) then query += "variable2 < y"; query += "and 1)" thus, I must not test if there is already a condition, and then to include an "and" etc... The problem is, OQL doesn't like "true" neither "one". What value may I use to force a positive comparision ? In SQL if I use the query "select * from TABLE where 1" I get all the rows. Thanks Gonçalo D. Luiz IST, Portugal. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]