Zeoslib Portal

I had a similar problem with Firebird a few months ago, so I re-installed Firebird. That cleared up the problem for me, but I never found out what was actually wrong.

I don't think you can execute multiple update statements at once. Try this QuotesZQuery.SQL.Clear; QuotesZQuery.SQL.Add('UPDATE LineItemTable SET DesignTime = ' + IntToStr(55) + ' WHERE Projectnumber=504 AND LineNumber=1;'); QuotesZQuery.ExecSQL; QuotesZQuery.SQL.Clear; QuotesZQuery.SQL.Add('UPDATE ...

Lutz.H wrote:I know that it is possible to solve this problem with
independent ZConnections. Lutz

This seems like an easy solution. Why do you want to avoid it? You could have several ZConnection components. One for the barcoder, one for the external event...as many as you need at one time.