Zeoslib Portal

I have a system that uses up to 10 decimals in some cases and this bug caught me.

The problem lies in UpdateBigDecimal in ZDBCInterbase6Utils

Please can you upload the code for your function so that I can see if I have a fix for it, It is possible that I have not made a commit for this fix.

mdaems - I have uploaded the source and database for a simple Delphi 2010 test project at this link: http://www.filehosting.org/file/details/165942/testproject.rar Note that I used the latest Zeos source from the Trunk of the SVN. Looking forward to your response and eagerly awaiting a fix soon :? ...

Please find the patches on the test branch

Hi Everyone I have released the patch for the exec stored procedure into the test branch. I seem to have exposed another bug though in doing this fix as I see when calling a stored procedure a second time I get a parameter mismatch, to fix this I simply prepare the procedure again but the correct so...

Hi Everyone

I've just got it together to release the patch for the INSERT ... RETURNING problem on Firebird. You'll have to get it from the SVN repository and give it a spin. Please post up your problems if you get any.

Perhaps a new forum for the testing of this may be in order.

Hi Mark The changes for the Firebird 2.5 release will cause us to make a new driver library for selection in the database options as there are new constants and the API calls have changed in how they work. I am testing the code for production purposes on Firebird on a comercial system specifically f...

I have fixed this problem, where can I post the code ?

Hi SF If I understand you correctly you want to cache data in memory, are you only talking about access via TZTable or all Zeos components ? I have done this type of manipulation with an inmemory dataset which loads from a zeos component and then one can manipulate the data, at the end of the sessio...

I have solved the problem of the returning values and now will start testing for backward compatibility.

Problem: Firebird 2.5 RC2 & 3 close the cursor on Stored Proc execution and insert / update returning statements I have the following suggestions to fix this for firebird 2.5, but this may require some type of if statement on the FreeStatement: Possible Solution and Seems to Work in my test envi...

Only a pleasure

Some feedback on this problem, Apparently the Result set is passed back in this instance with the call to isc_dsql_execute2 which allows for two params - currently in the code base the second parameter is not being used and is set to null. The current code in the engine calls the execute which opens...

Yes - use suspend in stored procedures that must return values, I do this all the time now so I can get back error messages, its a good way to do things and it makes coding a bit easier also, I now use only one set of components - namely TZQuery + Dataset All stored procs can be called using select ...

Hi There

You almost have it! Parameters in Delphi are prefixed like in stored proc with a : - so your id parameter in the TZQuery must be :id and not 'id', you can check if its correct by clicking on the params options in the TZQuery.

Hope you come right otherwise post again

I'm on the way to solving this problem as it is something that I need to have pretty urgently. There is a new constant available to free statements and keep the cursors open - DSQL_UNPREPARE which I have been playing with on the Free Statement procedures. On one of my projects a blank SQL gets gener...