Subject IB_SQL and external table: error on inserting
Author Markus Ostenried
Hi,

I created this external table:
CREATE TABLE EXTEST EXTERNAL
FILE 'C:\EXTEST.TBL' ( TESTINT INTEGER );

Then I went to the Browse form, inserted one record.
everything fine so far. but from now on when I post
a new inserted record I get this error:
>>>
Multiple rows in singleton fetch
check KeyLinks and JoinLinks properties
SELECT EXTEST.*
, EXTEST.RDB$DB_KEY
FROM EXTEST
WHERE EXTEST.RDB$DB_KEY=? /* BIND_0 */
<<<

If I Cancel and Refresh then the new record appears.

On the Fields tabsheet I see that the value of
RDB$DB_KEY is "0000000000000000".for all records.
Is this normal behavior for external tables ?

Anyway, this is not a problem for me, I just wanted
to let you know that IB_SQL shows an error when
inserting records into external tables.

regards,
Markus