Versant OQL Statement with an Arithmetic operator

Posted by Pascal on Stack Overflow See other posts from Stack Overflow or by Pascal
Published on 2010-06-08T20:17:20Z Indexed on 2010/06/09 4:22 UTC
Read the original article Hit count: 214

Filed under:

versant-object-database

|

vql

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

© Stack Overflow or respective owner

Related posts about versant-object-database

Versant OQL Statement with an Arithmetic operator

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Query on object id in VQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently working with the versant object database (using jvi), and have a case where I need to query the database based on an object id. What I'm trying to achieve is something along the lines of Employee employee = new Employee("Mr. Pickles"); session.commit(); FundVQLQuery q = new FundVQLQuery(session… >>> More

Related posts about vql

Query on object id in VQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently working with the versant object database (using jvi), and have a case where I need to query the database based on an object id. What I'm trying to achieve is something along the lines of Employee employee = new Employee("Mr. Pickles"); session.commit(); FundVQLQuery q = new FundVQLQuery(session… >>> More
Versant OQL Statement with an Arithmetic operator

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More