Helen Borrie wrote:

>At 12:41 PM 25/11/2004 +0100, you wrote:
>
>
>
>
>>Hi there!
>>Given the following table
>>
>>CREATE TABLE ELENA_TRIPLES (
>> SUBJECT VARCHAR(75),
>> PREDICATE VARCHAR(300),
>> OBJECT VARCHAR(5000)
>>);
>>
>>Has somebody an idea why the current statement wouldn't work with firebird.
>>
>>
>
>Yes. Firebird doesn't support derived tables (yet..)
>
>
>
>
>>SELECT triples.PREDICATE, triples.ARG0, triples.ARG1
>> FROM (SELECT 'http://test#goodTitle' AS PREDICATE, triples.SUBJECT AS
>>ARG0, triples.OBJECT AS ARG1
>> FROM ELENA_TRIPLES triples WHERE triples.PREDICATE
>>='http://purl.org/dc/elements/1.1/title'
>> AND triples.OBJECT = 'Artificial Intelligence'
>> UNION SELECT 'http://test#goodTitle' AS PREDICATE, triples.SUBJECT AS
>>ARG0, triples.OBJECT AS ARG1
>> FROM ELENA_TRIPLES triples WHERE triples.PREDICATE =
>>'http://purl.org/dc/elements/1.1/title'
>> AND triples.OBJECT = 'Just Java' ) triples
>> WHERE triples.PREDICATE = 'http://test#goodTitle'
>><http://test#goodTitle%27>
>>
>>This query
>>
>>
>
>
>
>
>
>>is acutally automatically generated by another component
>>(edutella provider for triple tables), but firebird doesn't seem to be
>>very happy with that.
>>
>>I put this query also in IBExpert, using fbclient.dll and it complaind
>>with the SELECT statement in row. May there be a way to just rewirte
>>this query in another way?
>>
>>
>
>Except for the strange bracketed URL at the end (what is this?) this query
>is meant to pick up a subset with a certain URL and return a substitute
>URL. Thus, it appears to resolve to something much simpler:
>
>SELECT
> 'http://test#goodTitle' AS PREDICATE,
> triples.SUBJECT AS ARG0,
> triples.OBJECT AS ARG1
>FROM ELENA_TRIPLES triples
> WHERE
> triples.PREDICATE ='http://purl.org/dc/elements/1.1/title'
> AND
> (triples.OBJECT = 'Artificial Intelligence'
> OR triples.OBJECT = 'Just Java')
>
>What is this element meant for?
><http://test#goodTitle%27>
>
>./heLen
>
>
>

thanks a lot .

The last term is actually typo of mine :)
hmmm, i guess I should try that out. many thanks

Tom