Zeos 7.3 testers-thread

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

aehimself wrote: 07.05.2020, 20:09 I guess if you delete it from GitHub only and try to push, it will either fail or recreate the remote branch; not sure. The real question is how branches are created when exporting via svn-all-fast-export...? Even if you delete your local branch, it might recreate it again just to return to the original state.
Anyhow; I don't mind my name being present on the unofficial repository ^^
Just to make sure what we are talking about. The current process looks like this:
  • sync a local copy of the Zeos SVN repo by using svnsync
  • use svn-all-fast-export to copy new changes from the local svn repo to a git repo
  • push any changes from the local git repo to the github repo using "git push github --all"
My hope would be that deleting the branch from the github repo would have no negative effect because the aehimself branch in the local repo should see no more changes and so git should not see any reason to try to push anything from the aehimself branch to github ever again. Does that make sense?
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 797
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Zeos 7.3 testers-thread

Post by aehimself »

Honestly, the worst thing that can happen imo is that something goes horribly wrong and the GitHub repository has to be recreated. Since I'm the only one who forked it until now - this will not have a huge impact. I'll just re-fork and re-push my own changes. Alas, following this thought the branch can also stay.

What I'd do is to delete the local branch, and start the sync (and fast export). Then check if the -aehimself branch was recreated or not. If not, just delete the branch on GitHub (git push --all means you are pushing all local branches. If there's no local -aehimself branch, it will not even be attempted to be pushed). If yes - then some help digging and googling on which step and how it is creating the branches.
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

I encouter a strange problem. When I compile already existing applcations I get an error when I try to open a report. I did some tests and when I drop the old query component and use a new one from zeos 7.3 then everything works. Do I have to change all query components when I use 7.3 with lazreports?
When I use zeos 3.7 build 5939 I don't have problems.

I use Windows 64 bits (1909 - 18363.778)
Lazaus 64 bits 2.08 R62944
fpc 3.,04
zeos 7.3 build 6513
SQLite version x64 3310100
You do not have the required permissions to view the files attached to this post.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Theo,

we had another user reporting a similar problem: viewtopic.php?f=50&t=118328
tkamphuis wrote: 12.05.2020, 10:04 [...] when I drop the old query component and use a new one from zeos 7.3 then everything works[...]
Do you use persistent fields, i.e. field components that are inserted in the form using the fields editor?
Normally you don't have to replace the query components. I can only assume that somehow some settings change or the field types change.

Best regards,

Jan
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 6514:
https://sourceforge.net/p/zeoslib/code- ... sting-7.3/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1) - Raspbian32 Buster for Raspberry Pi https://www.getlazarus.org/setup/?download#raspberry_pi,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

my mORMot PerfTest r5960 passes(Delphi 10.3.3 Rio Win32/Win64)

Michal
Last edited by miab3 on 12.05.2020, 21:16, edited 1 time in total.
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

Yes the problem is with the persitant fields, but I need that for reference to from other queries. In the past that was not a problem. The field types are not changed.

Kind regards

Theo
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

The problem with the persistent fields only arises in combination with lazreport. In queries not used for a report there is no problem.

Kind regards,

Theo
vbazovic
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 16.04.2014, 12:43

Re: Zeos 7.3 testers-thread

Post by vbazovic »

When cross compiling from GNU/Linux system (Debian and it's derivate) to Windows 64 there are some "caps" filename problems.

In files ./dbc/ZDbcAdoMetadata.pas:67, ./dbc/ZDbcAdo.pas:131, ./dbc/ZDbcOleDBStatement.pas:244, ./dbc/ZDbcOleDBMetaData.pas:52, ./dbc/ZDbcOleDB.pas:153 in uses there is ZDbcOleDBMetadata but file is called ./dbc/ZDbcOleDBMetaData.pas, it probably should be renamed to ./dbc/ZDbcOleDBMetadata.pas (with lowercase d).

In file ./dbc/ZDbcAdo.pas:131 there is a uses clause unit ZDbcAdoMetaData and it should be ZDbcAdoMetadata.

After this changes compiling is succesfull. FP IDE is CodeTyphon 7.10 but because it's a OS problem this problem is probably same with Lazarus.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello vbazovic,
vbazovic wrote: 13.05.2020, 10:29 ./dbc/ZDbcOleDB.pas:153 in uses there is ZDbcOleDBMetadata but file is called ./dbc/ZDbcOleDBMetaData.pas, it probably should be renamed to ./dbc/ZDbcOleDBMetadata.pas (with lowercase d).

In file ./dbc/ZDbcAdo.pas:131 there is a uses clause unit ZDbcAdoMetaData and it should be ZDbcAdoMetadata.
Your suggestions have been applied in Revision 6520. Best regards,

Jan
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Theo,
tkamphuis wrote: 12.05.2020, 14:03 Yes the problem is with the persitant fields, but I need that for reference to from other queries. In the past that was not a problem. The field types are not changed.
coud you send me the lfm-file of your form before and after the change - meaning the not working form file and the working form file? Also the declaration part of the pas file is needed to see what field types are generated by Zeos.

Best regards,

Jan
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

Here are the demos.

https://www.dropbox.com/t/MMUGrXl7pFSrXdFl

Best Regards,

Theo
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@Theo, Jan, Michael

Zeos 7.3 r6514

I checked "demo" and in Lazarus 2.0.8-Win64 entries about persistent fields are not saved to the unit .pas file.
In .lmf they are.
And in uses are missing entries: ZAbstractTable, ZAbstractRODataset, ZAbstractDataset, ZAbstractConnection;
The same happens in a newly created application.

Everything is fine in Delphi 10.3.3-Win32.
They are in .pas and in .dfm.

Michał
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

Zeos 7.3 r 6529
There is still no generation (entries to the unit) with persistent fields for Lazarus 2.0.8-Win64.
!!!

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

It seems that after patch r6532 persistent fields works in Lazarus too. !!!

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@All

ZEOS 7.3.x svn 6534:
https://sourceforge.net/p/zeoslib/code- ... sting-7.3/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1) - Raspbian32 Buster for Raspberry Pi https://www.getlazarus.org/setup/?download#raspberry_pi,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

my mORMot PerfTest r5960 passes(Delphi 10.3.3 Rio Win32/Win64)

Persistent fields works in Delphi and Lazarus.

Michal
Post Reply