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]