dbTalk Databases Forums  

OQL query problem !!!

comp.databases.object comp.databases.object


Discuss OQL query problem !!! in the comp.databases.object forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sridhar
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.