OQL query problem !!! -
07-07-2003
, 07:38 AM
Hi All,
I have a data base in OQL.
My main class is Material Class in this i have two more classes with
doku(all the objects in doku class) and
serialized_refs_param(parameters).
In one object of doku class i have set of parameters.
Now the question is i have to write a query to search a value(>,>,=
some value) called betrag in parameter of an object.
DEFINE resultset AS
SELECT material.serialized_refs_param
FROM MaterialExtent AS material,material.serialized_refs_param
AS parameter
WHERE material.doku.bezeichnung LIKE "P*";
SELECT *
FROM s IN resultset
WHERE s.wert.betrag > 1
This query doesnt work. This is quite similar to the example given in
the book.
Anybody has any idea or can anybody suggest me anything in this
regard.
That help will be highly appriciated.
Thanks in advance !!
--Choudary |