Zeoslib Portal

I am almost certain I'm missing a path declaration somewhere. When I start my script and it fails, I can not even build the package from the Delphi IDE anymore; I had to remove all z*.dcu files from Users\Public\Documents\...
Or I left one path declaration in when building 64 bit versions.

Hello, I am using Zeos 7.3 by DCUs. As the source of 7.3 is changing quickly (Thanks to the devs!!!) It's getting a bit slow to manually build each package for Win32 Debug, Win32 Release, Win64 Debug, Win64 Release so I decided to write a script for it. I can compile / build the first package (ZCore...

Hello aehimself, i've resolved your rangecheck regression see: https://sourceforge.net/p/zeoslib/code-0/6486/ Other devs like to take it easy when it comes to bug reports, but no, not you, guys. You are blazing fast. Seriously, hats off. puh your git was very very old, propably ... time for svn? :P...

I thought DateTime is unsupported in SQLite...? https://www.sqlite.org/datatype3.html 2.2. Date and Time Datatype SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as TEXT, REA...

Done. If everything works as expected, the Github repository will be updated daily at 0:30 now by a Jenkins job. We also could have it check the Zeos svn every xxx minutes and have it run then. Awesome job as ever, thank you very much! This all is still considered to be experimental. If things go w...

Jan, I see you added the test case to the repository, thank you for that. I am sorry that I am uncapable of debugging / fixing it myself - to be honest I dislike Variants and kind of afraid of them; I avoid them whenever I can. And exactly because of this - I have no experience. I also would like to...

testing-7.3-aehimself is obsolete, not updated for a really long time and the branch should be deleted from the (un)official Zeos git repository.
We used that to test how exactly patches can be pushed the easiest; but abandoned the idea a long time ago.

Just out of curiosity: I assume this is a 64 bits application? Yes, this is the output of my SQL Client, which is 64 bit. Indeed the latest 32 bit MySQL driver is 6.1.11.0 - the test was done with that one. I get range check errors on Delphi versions 2009 and XE 2. Also on FPC 3.0 and 3.2. Yes, for...

MySQL 8.0.18, client version: 8.0.18, database component version: 7.3.0-alpha CREATE TABLE `temp` ( `f` bigint(20) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf16; Preparation: q.SQL.Text := 'SELECT * FROM temp'; q.Open; Try q.Append; q.FieldByName('f').AsLargeInt := UInt64.MaxValue; q.A...

And the other way around, too.

[2020.04.27 15:44:14.262] SQL trace: '2020-04-27 15:04:14' cat: Execute, proto: mysql, msg: Statement 23 : UPDATE CapacityInfo SET DateTime = Created WHERE DateTime < 1562583615
[2020.04.27 15:44:14.398] Tab 0: Query affected 188 row(s) in 143 milliseconds

What the everliving f*ck...? Capture3.PNG I mean, even these numbers (barely but they do) fit into a UInt64, but honestly... if I can not read them out from the database, how did they get in?! I guess Zeos's only issue is that they don't really handle close-to-max UInt64 values. My issue lies somewh...

Refreshed, recompiled, different call stack; same error. I think the issue will be a little bit above, see: Capture.PNG As for bigint, according to Oracle: BIGINT 0 .. 2^64-1 ( https://dev.mysql.com/doc/refman/8.0/en/integer-types.html ) Delphi's UInt64 is exactly the same: Uint64 0 .. 1844674407370...

I have a project which connects to a MySQL database. After refreshing Zeos to the currently latest version on GIT, one of the queries started throwing range check errors in ZVariant.pas, line 2464: function TZSoftVariantManager.Convert(const Value: TZVariant; NewType: TZVariantType): TZVariant; [......

Np, glad I can contribute

object SQLConnection: TZConnection ControlsCodePage = cCP_UTF16 AutoEncodeStrings = True ClientCodepage = 'utf8mb4' Catalog = '' Properties.Strings = ( 'controls_cp=GET_ACP' 'codepage=utf8mb4') TransactIsolationLevel = tiReadUncommitted HostName = 'databasehost.lan' Port = 0 Database = 'database' Us...