Do I understand the situation?

The InsertSQL(and the other 2), provide a means to populate the parameters
automatically. What is still required is a TIB_DSQL component with which to
effect the intended changes to the dataset by the stored proc on the server.

... procedure AQryBeforePost(...
begin
with AStoredProc do
begin
{ values are assigned by IBO therefore: }
ExecSQL;
end;
end;

IBO Help:-

l As with EditSQL and DeleteSQL, when your dataset is the output of a SELECT
from a stored procedure, or a joined dataset where you want to your insert
to add rows to more than one table, it provides a way to pass parameters to
a stored procedure you have created to perform one or more operations that
will generate new rows in the dataset.

Thanks,
Dion.


-----Original Message-----
From: Helen Borrie (TeamIBO) [mailto:helebor@...]
Sent: Wednesday, January 16, 2002 10:39 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Join edit


At 07:24 AM 17-01-02 -0800, Dion wrote:

>I get the following error when the SP fires :-
>
> Message length error(encountered 0, expected 8)
>
>Is my column naming correct in the qry? I can only think that the params
>sucked into the SP are not the correct ones.

Why not show us the code you are using to assign the params and execute the
DML query?

Also, would you please trim your replies.


regards,
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
www.ibobjects.com



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/