Versant OQL Statement with an Arithmetic operator

Question

I'm working on a c# project that use a Versant Object Database back end and I'm trying to build a query that contains an arithmetic operator. The documentation states that it is supported but lack any example.

I'm trying to build something like this:

SELECT * FROM _orderItemObject WHERE _qtyOrdered - _qtySent > 0

If I try this statement in the Object Inspector I get a synthax error near the '-'.

Anyone has an example of a working VQL with that kind of statement?

Thanks

Answer 1

I am not sure that the Object Inspector will know the syntax for the arithmtic expression. However, in your code you should be referring to the fully qualified class. Then the syntax you are using should be perfectly fine.

Query query = new Query( session, "select * from com.yourCompany.yourClass where _qtyOrdered - _qtySent > 0 ");

QueryResult result = query.execute();

I just tried this out on one of my classes and it worked fine.

Cheers, -Robert