| Subject | RE: [IBO] Re: Firebird3 |
|---|---|
| Author | Jason Wharton |
| Post date | 2019-06-06T05:49:33Z |
So glad you figured that out. There is a difference in
how these values are acquired back from the server.
Jason Wharton
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Wednesday, May 29, 2019 1:39 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Firebird3
Here is some more information about the problem.
It has something to do with the query-Parser and the property
TIB_Query.KeyRelation
a Query with a Subquery and an empty Keyrelation like this
SELECT TXMANUMM,TXSPRACHE,TXTEXT,
(SELECT SPNAME FROM SPRACHE WHERE
SPRACHE.SPNUMM=TEXTEBEST.TXSPRACHE) as SPRACHE
FROM TEXTEBEST
ORDER BY TXSPRACHE
works with FB2.5 when i try to insert a row but not with the FB3.0
server.
I have to set the Keyrelation to
'TEXTEBEST' then it works with FB3.0 too.