Zeoslib Portal

OK, we're getting near the end of this issue: I have been using the hard_commit=yes optional parameter in the ZConnection. Removing it seems to have removed the behavior! I'll just have to encourage the user to click on a "Garbage Collect" button occasionally to do a quick disconnect/recon...

After doing a search on this forum for both "autocommit" and "FireBird," I think I see the source of my problem. ZEOS is doing soft commits to keep cursors open "across transactions," but I'm specifying hard commits to keep FireBird happy. Oh well. I guess the behavior ...

Here's a log file from the SQL monitor, showing the user connecting to the database, activating a query that is associated with an MDI parent form, activating a query that is associated with a new MDI child form, inserting a record by means of a DevExpress grid control on the child form, then closin...

To clarify further: Simply opening the form and activating the ZQuery, and then immediately deactivating the ZQuery and closing the form is no problem. Only if rows are inserted or deleted does closing the form cause the -501 error. That's a pretty good indication that there's something fishy with c...

More info: There's something fishy going on when a ZQuery is deactivated, and TZCachedResultSet.Close() is called. I am just learning the architecture of ZEOS, so things are a bit confusing... I have ZQuery.CachedUpdates = false, so why is there even a TZCachedResultSet present in the first place? I...

OK, I've caught up to the front of the SVN trunk, but the behavior hasn't changed. There's definitely some statement handle being allocated, but not opened, so that the act of closing before freeing it causes the error. I'll try my best to trace things, but I could sure use some help .

I'm using the 7.0.0 alpha package downloaded from SourceForge, dated 12-30-2009. I'm also using an up-to-date Firebird embedded client. Should I be using the latest CVS/SVN branch instead?

Hi everyone-- I'm using Delphi 2009 to compile an app that uses ZEOS to access a Firebird DB through the Firebird 2.1 embedded client. I'm dynamically building a ZQuery and ZUpdateObject to read and write to a table whose name and fields are unknown until the user sets a few things. So far, the crea...

Finishing up -- the root problem was that I was stupidly storing some XML in a VARCHAR field that was 16Kb long, instead of in a BLOB, and the row length overflowed. This must have been the root cause of the error that prevented the prepare, and thus prevented the connect (since I was activating the...

OK, things have progressed a bit... I moved the ZEOS components out of a data module I had set up, and placed them on my main form, and the error messages changed. Whereas before the debugger refused to step down into the ZConnection.Connect call, now apparently the connection succeeded -- revealing...

I'm seeing the same error message, using Firebird embedded 2.1 and Delphi 2009. I'm trying to activate a ZQuery, which is configured with SQL.Text = 'Select * from vConfig'. vConfig is a view with permissions set so that only a specific role can select from it -- and I've got the rolename parameter ...