I have a Master-Detail Grid. On Startup everything is ok. But after I
click to change the Ordering in the Detail-Grid, I cannot see the
Detail-Records from the other Master-Records anymore.
I uses the DB-Monitor and found that after Ordering-Clicking the
sql for the Detail has another "AND .." that causes this. I dont
know why IBO add this 'AND..' ??

My Detail-SQL:
sql='select STRG_ID,FEHLER_ID,NAME,BESCHREIBUNG,URSACHE from fehler'
MasterLinks='fehler.strg_id=strg.strg_id'
Ordering-Items=FEHLER_ID=fehler_id;fehler_id DESC
NAME=NAME;NAME DESC



In the DB-Monitor I get after the Ordering-Click:
/*---
PREPARE STATEMENT
TR_HANDLE = 4026584
STMT_HANDLE = 4026640

select STRG_ID,FEHLER_ID,NAME,BESCHREIBUNG,URSACHE from fehler
WHERE fehler.strg_id=? /* MLNK_STRG_ID_0 */
AND strg_id=1
ORDER BY fehler_id DESC

PLAN SORT ((FEHLER INDEX (RDB$PRIMARY10)))

FIELDS = [ Version 1 SQLd 5 SQLn 32
FEHLER.STRG_ID[STRG_ID] = <NIL>
FEHLER.FEHLER_ID[FEHLER_ID] = <NIL>
FEHLER.NAME = <NIL>
FEHLER.BESCHREIBUNG = <NIL>
FEHLER.URSACHE[URSACHE] = <NIL> ]

SECONDS = 0,015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 4026584
STMT_HANDLE = 4026640
PARAMS = [ Version 1 SQLd 1 SQLn 1
[MLNK_STRG_ID_0] = 1 ]
----*/



Ulfried