Thomas-
Yes, i think you are correct. thanks for clarifying.
I will improve the error message. it should say:
Error: You have provided primary key "sequence_type_id = 1" which does
not exist. When inserting, do not provide a primary key (one will be
generated automatically). When updating, provide an existing primary key.
steve
Thomas Otto wrote:
> Hi,
>
> I had the same problem... the thing is, that the primary key will be
> set automatically, so you cannot set it. If the primary key exists, a
> update will be done.
> So just write command without the primarykey (sequence_type_id).
>
> Cheers,
> Thomas
>
> Fidel Salas wrote:
>
>> Steve,
>>
>> Revision 1.7, I believe, has a bug not found in revision 1.4.
>> It is expressed when one tries to insert a row with an id that does
>> not yet exist in the database. The bug is the updateRow method. See
>> the following insert invocation:
>>
>> ga GUS::Common::Plugin::SubmitRow --tablename DoTS::SequenceType
>> --attrlist
>> sequence_type_id,nucleotide_type,sub_type,strand,hierarchy,parent_sequence_type_id,name,description
>> --valuelist "1^^^DNA^^^null^^^null^^^1^^^1^^^DNA^^^unkown
>> strandedness" --commit
>> Reading properties from
>> /home/fisal/GUS/dev/gushome/config/GUS-PluginMgr.prop
>> Reading properties from /home/fisal/GUS/dev/.gus.properties
>> Tue Feb 17 12:19:19 2004 ALGINVID 78
>> Tue Feb 17 12:19:19 2004 COMMIT commit on
>>
>> ERROR: Can't update. No row found with primary key sequence_type_id = 1
>>
>>
>> Anyway, I went back to using revision 1.4.
>>
>> Fidel
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
>> Build and deploy apps & Web services for Linux with
>> a free DVD software kit from IBM. Click Now!
>> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
>> _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
>>
>>
>
>
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
|
