>Which tutorial was this exactly? I don't recognize it right off.

When installing IBO the directory tutorial\basictutorials are created. In
that directory you'll find tutorial1 through tutorial6. Jörg Schiemann is
referring to the first of these tutorials and the sql property of the
scrMain TIB_Script component. I took a look at it, got the same error as
him, but didn't instantly see what was wrong. I might take a further look
if I get the time today - but if I haven't sent an answer before you wake
up and start IBOing Jason, I didn't find enough time.

Set

At 02:36 01.12.2000 -0700, Jason wrote:

>Which tutorial was this exactly? I don't recognize it right off.
>
>Thanks,
>Jason Wharton
>CPS - Mesa AZ
>http://www.ibobjects.com
>
>
>----- Original Message -----
>From: "Jörg Schiemann" <schimmi@...>
>To: <IBObjects@egroups.com>
>Sent: Friday, November 17, 2000 4:03 AM
>Subject: [IBO] IBO's basic tutorials
>
>
>> Hi,
>>
>> As a new IBO user I'am testing the basic tutorial which follows with
>> IBObjects.
>> Already with tutorial1 the trouble begins. :-(
>> I'm using Interbase 6.0
>>
>> I noticed that the procedure SP_GEN_DUMMY_ITEM doesn't work.
>> Here is the procedure:
>>
>> DECLARE VARIABLE i INTEGER;
>> BEGIN
>> i = 1;
>> WHILE ( i <= :P_COUNT ) DO BEGIN
>> INSERT INTO ITEM(ID_CATEGORY, DESCRIPTION, BARCODE, COST_PRICE,
>> CURR_VALUE)
>> VALUES( :P_CATEGORY_ID,
>> ( :P_DESCRIPTION || ' ' || :i ),
>> ( :P_BAR_PREFIX || ( :P_CATEGORY_ID * ( 100000 + :i ) + :i *
>> 10000 + :i * 10 + :P_CATEGORY_ID ) ),
>> ( :i * 121 + :P_CATEGORY_ID * 10 + :i ),
>> ( :i * 59 ) );
>> i = i + 1;
>> END /* WHILE */
>> END
>>
>>
>> I've got the errormessage:
>>
>> ISC ERROR CODE:335544321
>> ISC ERROR MESSAGE:
>> arithmetic exception, numeric overflow, or string truncation
>> STATEMENT:
>> TIB_DSQL: "IB_Script."
>>
>> SQL ERROR CODE:-802
>> SQL ERROR MESSAGE:
>> Arithmetic overflow or division by zero has occurred.
>>
>>
>> After I changed the procedure to:
>>
>> DECLARE VARIABLE i INTEGER;
>> DECLARE VARIABLE b INTEGER;
>> BEGIN
>> i = 1;
>> WHILE ( i <= :P_COUNT ) DO BEGIN
>> b = ( :P_CATEGORY_ID * ( 100000 + :i ) + :i * 10000 + :i * 10 +
>> :P_CATEGORY_ID );
>> INSERT INTO ITEM(ID_CATEGORY, DESCRIPTION, BARCODE, COST_PRICE,
>> CURR_VALUE)
>> VALUES( :P_CATEGORY_ID,
>> ( :P_DESCRIPTION || ' ' || :i ),
>> ( :P_BAR_PREFIX || :b || :i ),
>> ( :i * 121 + :P_CATEGORY_ID * 10 + :i ),
>> ( :i * 59 ) );
>> i = i + 1;
>> END /* WHILE */
>> END
>>
>> it works.
>>
>> I don't know if it's only me who had the problem.
>> Neither do I understand why the error occurs.
>>
>> Could someone else test it?
>>
>> Regards,
>> Jörg Schiemann
>>
>
>
>
>
>
>
>