Hallo Dieter,

to which component should "PreparedInserts" belong to ?
Never heard about this !!??

Harald



Dieter Tremel schrieb:

>
> 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
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/