At 01:07 PM 13-03-02 +0100, Lucas Franzen wrote:

>But now it occured with just a normal TIB_Cursor which did a SELECT *
>from MYTABLE, assigned some values to some fields and then tried to post
>it...

Luc,
Yes, with ib_cursor, I get exactly the same (bad) behaviour. Here's the
monitor output:

/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14824036
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14824036
STMT_HANDLE = 14825152

INSERT INTO INV_HEADER
( INV_HEADER.ID
, INV_HEADER.FIELD1
, INV_HEADER.FIELD2)
VALUES
( ? /* INV_HEADER.ID */
, ? /* INV_HEADER.FIELD1 */
, ? /* INV_HEADER.FIELD2 */ )

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME = <NIL> ]

ERRCODE = 335544569
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14824036
STMT_HANDLE = 14825152

INSERT INTO INV_HEADER
( INV_HEADER.ID
, INV_HEADER.FIELD1
, INV_HEADER.FIELD2)
VALUES
( ? /* PRM_0 */
, ? /* PRM_1 */
, ? /* PRM_2 */ )

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME = <NIL> ]

ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =

SECONDS = 0.060

ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -104

ERRCODE = 31
----*/
/*---
INTERPRETE BUFFER = Token unknown - line 2, char 13

ERRCODE = 1
----*/
/*---
INTERPRETE BUFFER = .

ERRCODE = -1
----*/

It is barfing on the punkt at the first table identifier in the column list.

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________