I have a situation I can't figure out. I am getting two different
errors under the same scenerio. First error is a "token unknown line
1 char 18 EMPLOYEE" the other one is a "Attempt to execute an
unprepared dynamic SQL statement".

This is baffling to me since this error happens on the same table
when doing an update of the table. The only difference is the column
that I'm updating.

I can prevent the error from happening by having the Master query
only retreive one record but if I tell the query to retreive all
records then I get the error. The weird thing is that I'm, only
updating the detail record and not the master one.

Another way to eliminate the error is to remove the Master Query from
the transaction and only leave the detail record in the transaction.
It works just fine in this scenerio.

I have captured the SQL statements with the SQL monitor and could
email them to someone who knows more than I if someone would be
willing to take a look.

It would take a very long time to explain all the details of the
program and this specific form, but here are the basics.

I have a form with a TIBOTransaction on it. The form creates several
DataModules each with multiple TIBOQuery's on it. All of the
TIBOQuery's on all of the DataModules have their IB_Transaction
property set to the TIBOTransaction that is on the form.

There is a header Query "EMPLOYEE" and some detail query's. The one
I'm having the problem with is the "TASK" Query. I'm only updating a
column on the TASSK query but if I have more than one record
retreived for the EMPLOYEE header then I get one of the above
mentioned erros depending upon which column I update. There is no
other code or stuff runing that would affect this.

Again if I set the IB_Transaction of the EMPLOYEE query to nil then
it works just fine in all scenerios, but obviously I want it in the
same transaction since I could update both during the same
transaction.

If someone could please let me send them the SLQ monitor logs for the
scenerio with the single record verses the multiple records this
would probably make a lot more sense. When I look at the log I see
one big difference. When it errors out on me I see a huge prepare of
the EMPLOYEE query that is not needed.

Any help at all would be appreciated. I know this is probably very
confusing.

Thanks.