Zeoslib Portal

The rollback is only a test to see if the component can be freed.

The problem is that the form can not be freed with the TZTransaction inside it.

Have started creating the test app. The failing of freeing the TZTransaction is clear. This happens after i do this: Opening the form2 with a TZConnection to Firebird and a TZTransaction connected to it. Autocommit is false on both. Form2 := TForm2.Create(Self); Form2.DBConnection.Connect; Form2.ZTr...

I will create a demo app when i have time. Multiple transactions is great. But it works good without the extra TZTransaction. Though with only one transaction. You do one amazing work on Zeos i have to say. It also seems like it has memory leaks in the 7.3 version. Even if i close the IZResultset, i...

Something i noticed. Impossible to free the TZTransaction. Gives in transaction error or something like that. Also impossible to free a form with TZTransaction inside it. SQL monitor dont give the DB SQL error. Only give the SQL string as an error and no error. But, doing an exception handler instea...

It works. I realized that this is the same way FlameRobin do it. Because it works on select's but fails on procedures. So, it has to be the same thing. You can not add order by on procedure calls. You can only have order by inside the procedures. Finding the last Order By clause that is not in any s...

Thanks for the metadata tip. Always great to get help and tips. I did more testing, and you are correct. It still loading all the records at once. But the grid is loading what i set, so that s working. Maybe there is no solution on user executed SQL after all. Too little testing from my side. I will...

I solved all the sorting issues. Also on the user executed SQLs. I just wanted to let you know how i did it. I don't use the IZResultSet or DBCResultset other than getting metadata, but using the ZQuery, and set SortedFields, and then i created a custom function that loads 500 records at once. And w...

I think i know how to getting the transaction row number on the SQL executed by the user. I already have implemented a chack if it is a select statement, and added the RDB$DB_KEY to the end of the first select in the SQL. So, in Firebird it works good. I can do the same with other engines, with gett...

Thank you Jan :D You answered so professional that i became amazed. Wish it could be the same elsewhere too :roll: Yes, it's for the DB admin app. I will create a little sample application for you to see the thing you think is a bug. You helped me allot. I can now continue with some other solution. ...

I'm trying to get it all working, but problem after problem. Three big problems i am struggling with. 1: When using TZQuery, i set SortedFields to Firstname. The DBCResultset will not work. When going 10 records forward from the first record, I get the correct row, and it works on the next rows too....