Ok so found the files section on this site and have put a file
SampleTransactionProblem.zip there. I was able to duplicate the
problem in single sample EXE. I also included a backup of the
database that I reproduced the error with. It is a very small
database and only has one table and 28 records in it. Total file
size is only: 14.3K. Take a look at the readme.txt inside of the zip
for more info or email me.

Thanks,

Matt

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 12:09 AM 13/12/2003 +0000, you wrote:
> >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.
>
> Yup, something is configured wrongly. Send also the offending pas
and dfm
> files.
>
> Zip it up and send it to me. I'm on a max. 20Kbps dialup so be
gentle.
>
> Helen