You are right. Stupid me. Actually, I'm trying insert releaseSource on
releaseCRC, because the order on my database is diferent than my script.
Allways is good make inserts qualifying all columns. Tanks by the points...

Marcos.


Alan McDonald wrote:

>It works for a test for me but I am fully qualifying the insert. Please try
>it again in IBExpert first by trying
>
>
>
>>>insert into releases (ReleaseID, FileID, releaseout, relaseouttime,
>>>
>>>
>releaseintime, taskid, developerid, releasenum,
>
>
>>> releaseAge, releaseCrc, releaseDescription, releaseSource)
>>>select
>>> :newReleaseID, :newFileID, 0, null, current_timestamp, null, null, 1,
>>> releases.releaseAge, releases.releaseCrc, releases.releaseDescription,
>>>
>>>
>releases.releaseSource
>
>
>>>from
>>> releases
>>>where
>>> releases.releaseID = :releaseID;
>>>
>>>
>
>check me but you get my drift
>
>Alan
>
>
>
>>-----Original Message-----
>>From: Marcos Vinicius Dufloth [mailto:marvin@...]
>>Sent: Saturday, 5 July 2003 12:33 AM
>>To: firebird-support@yahoogroups.com
>>Subject: Re: [firebird-support] BLOBs and Triggers
>>
>>
>>Yep, same error if I try make an manual insert like this on IBExpert.
>>There's no truncation and I insert in this table using Delphi without
>>problems. The problem is that I would copy files and releases to a new
>>rows, under a new version number (if you don't realize, this is an VCS
>>system). I can make this on Delphi, but it will increase network traffic
>>without needed. Just I wonder if I can do it on server side...
>>
>>Marcos.
>>
>>
>>Alan McDonald wrote:
>>
>>
>>
>>>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/
>>>
>>>
>>>
>>>
>>>
>>>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/
>>
>>
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>
>>*__________________________________________________________________*
>>*Marcos Vinicius Dufloth*
>>*ICQ#: 128291190
>>
>>Tecnocyber, Ltda
>>Erechim - RS - Brasil
>>*
>>
>>*+* *Outras formas de contato * <http://wwp.icq.com/128291190>
>>*__________________________________________________________________*
>>
>>
>>
>>[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/
>>
>>
>>
>>
>
>
>
>
>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/
>
>
>
>
>
>

--

*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*ICQ#: 128291190

Tecnocyber, Ltda
Erechim - RS - Brasil
*

*+* *Outras formas de contato * <http://wwp.icq.com/128291190>
*__________________________________________________________________*



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