And you are sure it's not a truncation somewhere else in the trigger?
My gut does not like the not null blob fields - never done that and probably
never would but maybe it's OK
Can you (have you tried to) make a manual insertion with this statement not
in the context of the trigger?
Alan

> -----Original Message-----
> From: Marcos Vinicius Dufloth [mailto:marvin@...]
> Sent: Saturday, 5 July 2003 12:03 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] BLOBs and Triggers
>
>
> Ooops, here the domains:
>
> create domain objectID integer;
> create domain boolean smallint default 0 check(value = 0 or value = 1);
> create domain text blob sub_type 1;
> create domain binary blob sub_type 0;
>
> The select is made inside a trigger, and the parameters are local
> variables that are initialized before this select.
>
> Marcos.
>
>
> Alan McDonald wrote:
>
> >>Alan, it's blob to blob. The table is the same. I getting from one row
> >>and inserting in another row (modifying pk, of course). And I forgot
> >>I'm using FB 1.5 RC3.
> >>Below the table and the insert statement:
> >>
> >>create table releases (
> >> releaseID objectID not null,
> >> fileID objectID not null,
> >> releaseOut boolean not null,
> >> releaseOutTime timestamp,
> >> releaseInTime timestamp,
> >> taskID objectID,
> >> developerID objectID,
> >> releaseNum smallint default 1 not null check (releaseNum
> >> > 0),
> >> releaseAge timestamp not null,
> >> releaseCrc integer,
> >> releaseDescription text not null,
> >> releaseSource binary not null,
> >> constraint releasesPK primary key (releaseID)
> >>);
> >>
> >>...
> >>insert into releases
> >>select
> >> :newReleaseID, :newFileID, 0, null, current_timestamp, null, null, 1,
> >> releaseAge, releaseCrc, releaseDescription, releaseSource
> >>from
> >> releases
> >>where
> >> releaseID = :releaseID;
> >>
> >>
> >>
> >
> >What's the domain text? How is it defined? and binary?
> >Why are you using parameters in the select? Is this how you are
> running the
> >query in an admin tool or in your application?
> >
> >Alan
> >
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
>
>
>
>

[Non-text portions of this message have been removed]



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/