Daniel,

At 03:07 AM 2/07/2005 +0000, you wrote:

>Thanks to Helen and Luc I found the problem it was a null value in a
>query.
>
>Helen, I removed all the suspend from my execute SP, you mention
>masterlinks, I'm not sure what you mean.

Off-topic in firebird-support, but...
It is a property of an IBO query, used for linking a foreign key to the
master's primary key in a master-detail relationship.

>In a non updatable IBOQuery I use a simple join in the sql
>select * from spares
>join tires on spares.idtire = tires.idtire;

This is not legal syntax for a Firebird 1.5 join. It should be \
select s.* from spares s
join tires t
on s.idtire = t.idtire;

It doesn't seem relevant, though.

>I have nothing in insertsql, editsql, and deletesql

Without valid insertsql, you would not be able to insert into the above set.

>nothing in keylinks,

You need keylinks.

>joinlinks

Needed for joined queries that use the SQL-89 inner join syntax. You use
JoinLinks to identify the join criteria in the WHERE clause. Not relevant
here.

>there are keylinks defined for both tables.

Earlier you said you had nothing in KeyLinks...

If you still have problems you should take this thread to the IBO list. At
the moment you are posting aspects of the same client-side problem in two
lists and have also sent me private email about it.

./heLen