Geoff

> I just ran a quick test here (IBO_4_2_Da, Delphi5) and it seemed to
> work as expected on my Dialect3 database. Have you tried running the
> SQL monitor to see what is actually being prepared and sent to the
> server?

I have seen this problem on IBO3 but can't remember when.

I have started the machine cold, download a clean copy of IB_SQL from the
website, and am testing with that.

I have a simple 34 line table which was Dialect1 - have created a Dialect3
clone as well, and the target is just a copy of either with the lines
deleted. ( Don't need to delete them as I get the problem before it complains
that lines exist ).

I am running Firebird 0.9.4, but I think the problem is IBO end.

Running monitor, I hit <Prepare>and get the prepares for the Source, second
copy of Source and Destination. I then switch to <Execute> and on the first
activation I get another prepare of the Source and a check of the count, at
which time it fails. I then hit <Execute> again and see a prepare of the
insert and it runs line by line to completion.

What should I look for next?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services