Hallo ,

it's the first time I use PreparedInserts := False, since I default
some values of a record by Beforeinsert-Triggers (D5E German, 4.2 Ha,
FB1.0).
I set the PreparedInserts := False in the BeforePrepare Callback of the
TIB_Query, which is "select * from belegzeilen". When I do not set it
to false, every thing is OK but my Trigger does not default the
values.

The Monitor show the error that is reported when I actually do a
insert. The Field SKONTIERT is of my Boolean Domain

CREATE DOMAIN BOOL_D CHAR( 1 )
CHARACTER SET WIN1252
default 'F'
check (value in ('F', 'T'))
COLLATE PXW_INTL

but defined locally not NULL

, SKONTIERT BOOL_D NOT NULL

I actually do not set SKONTIERT at the GUI, but the field ARTIKELNR
instead, but the insert sql does not reflect it.

Any ideas?

Thank You Dieter Tremel

Monitor output:

INSERT INTO BELEGZEILEN
( BELEGID
, BELEGART
, BELEGNR
, LFDNR
, ANZAHL
, SKONTIERT )
VALUES
( ? /* BELEGID */
, ? /* BELEGART */
, ? /* BELEGNR */
, ? /* LFDNR */
, ? /* ANZAHL */
, ? /* SKONTIERT */ )

PARAMS = [ Version 1 SQLd 6 SQLn 6
BELEGZEILEN.BELEGID = 2
BELEGZEILEN.BELEGART = 'Angebot'
BELEGZEILEN.BELEGNR = 2
BELEGZEILEN.LFDNR = 1000
BELEGZEILEN.ANZAHL = 1
"ñ
þÿ"."" = <NIL> ]

ERRCODE = 335544569
INTERPRETE BUFFER =

SECONDS = 0,020

ERRCODE = 17
----*/
/*---
[ 3.5.2002 08:13:04 ]
INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21
----*/
/*---
[ 3.5.2002 08:13:04 ]
INTERPRETE BUFFER = SQL error code = -804

ERRCODE = 39
----*/
/*---
[ 3.5.2002 08:13:04 ]
INTERPRETE BUFFER = Incorrect values within SQLDA structure

ERRCODE = -1
----*/
/*===
[ 3.5.2002 08:13:04 ]
//>>> ERROR <<<//
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure