Subject | IB_SQL and external table: error on inserting |
---|---|
Author | Markus Ostenried |
Post date | 2002-06-11T23:25:28Z |
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:
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
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