Subject Re : Helen RE: [IBO] Problem with stored procedures: ISC ERROR MESSAGE:message length error (encountered 0, expected 8)
Author Adrian Wreyford
Dear Helen

Perhaps I should point out that the snippet of code in question, has been
working just fine for the last few years.
The error occurs upon the call to PROCGETNEWID.ExecProc;, before the next
line of code is executed. Just for the fun I changed the code, but for
obvious reason I can't test your suggestion.

So once again if you can look into it. I recently upgraded IBOobjects from
4.2F? to 4.2Hg, then added the Hh,Hi patches and recompiled the components,
without any problems. I then rebuilt my project, tested it here and there,
then deployed it in my practice this morning, and then chaos!!!.
We couldn't issue invoices, or add new records. We keep on getting this
error. I hope to be able to sort this out bewfore tomorrow, as I have a full
day consulting tomorrow in my practice.

PS Regarding the flooding of the server with request I apologise!!!
I sent the email to the group, but it never appeared.
I then out of despatration joined the yahoo website, to join the group and
posted my request there.
I don't know how that resulted in the flooding, but then I'm just a surgeon,
and don't always understand these intricacies.

Can you perhaps let me know which email is registered for the list that I
have always been using


Adrian Wreyford

-----Original Message-----
From: Helen Borrie (TeamIBO) [mailto:helebor@...]
Sent: 13 August 2002 01:15
Subject: Re: [IBO] Problem with stored procedures: ISC ERROR
MESSAGE:message length error (encountered 0, expected 8)

At 05:50 PM 12-08-02 +0200, you wrote:
>Dear Jason.
>Please if you could help. My messages just don't want to appear on the
>The problem I tried to post is as follows.
>Error message now while stored procedure is executed.
>function TPraxData.GetNewID(const aTable: String): Integer;
>{ call the stored procedure to get a new ID }
>PROCGETNEWID.ParamByName('TABLENAME').AsString := AnsiUpperCase(aTable);

Next line is the cause of the problem:

>Result := PROCGETNEWID.ParamByName('NEW_ID').AsInteger;

Should be
Result := PROCGETNEWID.FieldByName('NEW_ID').AsInteger;
Stored procs use the Params[] array for input parameters and the Fields[]
array for output parameters.

>when this call is executed :: PROCGETNEWID.ExecProc;
>I get the following error:
>ISC ERROR CODE:335544358
>message length error (encountered 0, expected 8)

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to