Error checking // FEW records at once

[Ruslan Zasukhin]

On 21/9/07 12:26 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hmm, I adapted the sp
> 
> create or replace procedure cm_spBuildUserTypes()
> begin
> DECLARE mylastrecid Long;
> insert into tbl_typelists(created_by,typelistname) values
> ('cm_spBuildUserTypes','usertypes');
> set mylastrecid = select recid FROM tbl_typelists where typelistname
> = 'usertypes';
> insert into tbl_typelistvalues
> (displayname,listvalue,objptr_typelist) values ('active',1,mylastrecid),
> ('deactivated',2,mylastrecid),
> ('blocked',3,mylastrecid);
> exception
> when 50000 then
>       print 'dummy';
>      when others then
>        print 'something went wrong';
> end
> 
> which is refused by the parser, the console gives:
> 
> Kernel error: 0x21502. It's too much values.

Try wrap all by  ()

I need check now self, but should works


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]