Is the isc error code 335544321?

If that's the case you must change the domain T_CODE in scrMain
(the fourth line) from
CREATE DOMAIN T_CODE AS VARCHAR(20) NOT NULL;
to
CREATE DOMAIN T_CODE AS VARCHAR(30) NOT NULL;

For some reason IB6 insists to add '.0000000000' to all calculations of
barcode when using

( :P_BAR_PREFIX || ( :P_CATEGORY_ID * ( 100000 + :i ) + :i * 10000 + :i *
10 + :P_CATEGORY_ID ) ),

in the SP_GEN_DUMMY_ITEM procedure. I haven't got a clue why why it
transforms integers this way, but Jason or Helen might know.

Regards,
Jörg Schiemann
--
joerg@... - Often in Error, Never in Doubt!
GNU Privacy Guard public key available on request. -=protect your privacy=-
GPG Key ID: 1024D/549A4379
GPG Key fingerprint: 27F2 B968 D4AA 3BFA D4AE 914C BEFF 660F 549A 4379

----- Original Message -----
From: "Lin MacDonald" <linco@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 03, 2001 6:45 AM
Subject: [IBO] Re: Real, super Newbie question


> --- In IBObjects@egroups.com, Helen Borrie <helebor@w...> wrote:
>
> > You will need to connect the IB_Connection to the Tutorial.gdb database.
> > Did you do that? (Click the blue '+' sign on the tool bar).
> >
> > then, once the '-' button is enabled (you are connected) click the blue
> > book button to open the dataset. You should then see all of the
> members of
> > the Item table.
> >
> > Look at the handler code behind each of the buttons - there is
> comment text
> > there to explain what is going on...
> >
> > Helen
> >
> >
>
> Helen;
>
> I did connect the IB_Connection. The first time I tried, I got an
> error: "raised exception...class EIB_ISCERROR...arithmetic exception,
> numeric overflow or string truncation."
>
> The following code came up as flagged:
>
> if RExcept then
> raise EIB_ISCError.CreateISC( Sender,
> tmpText,
> errcode,
> error_messages,
> error_codes,
> SQLCODE,
> sql_messages,
> sql_text );
>
> I tried manually connecting the database, etc, to no avail. I tried
> executing the script file that was attached to the IB_Connection and
> got another error: "Invalid create, connect or drop database syntax".
>
> Because I am so new to IB_Objects and to Interbase, I don't know how
> to track the problem down -- and it's a little difficult to learn if
> you can't get Part 1 of the tutorial to work!
>
> I'd really appreciate some guidance on this one,
>
> Thanks,
>
> Lin
>
>
>
>
>