At 09:59 PM 1/02/2004 +0100, you wrote:

>Hello,
>
>I have spend more time going through Helen's code and my code as to
>pinpoint the root of the problem, but I am still as a loss.
>
>The code works fine until I add the following code to TIBOQuery's
>InsertSQL component
>
>EXECUTE PROCEDURE INS_OR_UPD_OR_DEL_E_PROJECT('N', -1, :WWWCON_ID,
>:WWWDESC_TEXT,
> :WWWCAD, :WWWPROJECT, :WWWPROJECT_TYPE)
>
>Only substituting the parameters with constants made the insert work.
>Obviously that will not be of very much use.

It seems you didn't get around to fixing up those input parameter
names. If the parameter names don't match, the IBO parser can't do
anything with them when it comes to construct the DML statement.

>Would someone very much taking another look at my problem?

I hope someone does. I feel I've wasted time on this (a LOT of time).

In the meantime, I've done you another demo using the same SPs as before
but, this time, removing the DML operations from the dataset and putting
them into a separate IB_DSQL.

Though I think it would be a Good Thing (TM) for you to get your head
around the parameters issue, at least this second approach will handle the
mismatched parameter names if you are determined to stick with them.

Please DO read the commentary at the top of the .pas file.
Download here:
File : /ronan2.zip
Uploaded by : helebor <helebor@...>
Description : Demo using IBOQuery with 2 stored procedures

You can access the file at the URL

http://groups.yahoo.com/group/IBObjects/files/ronan2.zip

Helen