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