Zeoslib Portal

Hello Darsh, as mentioned in my other post : Zeos 7.3 has been renamed to Zeos 8.0. See the 8.0-patches branch in the Subversion repository or in the GIT repository on GitHub . Also note that support for Delphi 12 is not included yet. A patch is waiting for testing and integration: https://github.co...

Hello essence-ciel, i am not sure, what you try to do. But: Your code in TDataModule1.TAffectionsAfterPost doesn't make sense. Even worse - usually this will put you into an infinite loop because you call post, which will call AfterPost which will call Post which will call AfterPost ........... Call...

I am sorry, in that case it should be procedure tfrmUserRec (Sender: TObject; Field: TField); begin if field =nil then statbar.text:=inttostr( recno) else if Field.FieldName = 'AMOUNT' then begin sum:=sum+field.curvalue; //calculated three times showmessage(field.fieldname); //showed three times; en...

medhome wrote: ↑25.10.2023, 15:50 ANY IDEA ? ( THIS CONCERNS FREE PASCAL OR LAZARURUS );

I suggest to check that the field name is correct. Something like if Field.FieldName = 'NTIERS'.

As to why this gets called for all fields: This might be a problem in FPC.

Hello xutanou, we did quite some debugging on my machine today to find out what happens. All this is about Zeos finding out the value of the identity column. There may be several things to consider: 1) ADO-ODBC-Bridge The way you use the ADO driver you always use the ADO-ODBC-Bridge which is somethi...

I am not sure if TZSQLProcessor starts a transaction automatically. Is AutoCommit set to true on your connection? Since the create database statement really is only one statement, you don't need to use TZSQLProcessor. What happens, if you do something like the follwing code block? script := 'CREATE ...

Hello xutanou,

xutanou wrote: ↑13.10.2023, 17:17 "INVALID VARIANT TYPE CAST"

This usually is a programming error in the user program - including Zeos. So I agree with aehimself: we need an example on how to reproduce the error.

$(ZEOS)\src\webservice It shouldn't be necessary to add the webservice folder. The webservice folder is the home of the webservice server. All files that the webservice client needs are in the dbc path already. I just had no idea how to organize things in a better way. Maybe wevservice needs to be ...

Bookmarks are not safe for my needs but RDB$DB_KEY seems safe to me: It is persistent in the tables until backup/restore and is unique in the table. Sure, it can be reused after the garbage collector cleans up the data, but when i need DB_KEY there is ever a live transaction that the GC can't clean...

Hello RedHead, we don't support Code Typhoon. Zeos 7.3.0-alpha is - as the name says - an alpha version. This version is really old and was never meant to be included in any stable software. Please uninstall this version and check wether the problem also happens with the current 8.0-patches branch f...

As far as I remember all bookmarks become invalid if you close and reopen (refresh) a dataset. You can solve what you are looking for is taking the value of all index fields prior and use TDataSet.Locate on the same fields after the refresh. This is correct. Bookmarks are only meant to be used whil...

Hello Daniele, You could hook a TZSqlMonitor to your connextion and see if the statement gets executed. If it is in the log, it gets executed and you will have to take a look at the database side. Also it makes ense to look at the transaction management: Maybe the statement gets executed but the tra...

Hello Siegbert, that sounds strange. I maintain an application with Firebiord and didn't see that problöem yet. A test case that demonstrates the problem really would help. Could you please make sure that you update to the latest Zeos 8.0 revision from SVN (branches/8.0-patches) or from Github (8.0-...

Hmm - that sounds strange. Without a reproducible example it will be hard to debug. I could create a link on our nextcloud instance and send it to you via PN, so you could upload your project there. Could you create a log using TZSQLMonitor? Maybe that reveals something strange? With best regards, Jan

Hello, the code you mention usually doesn't do any reconnection. It is meant to clean up memory only. I seem to remember that there is / was a function in older mysql versions that tries to reconnect to the database, in the event of a connection loss. But I think that was changed in modern versions ...