Search found 754 matches

by aehimself
10.01.2023, 10:29
Forum: ZeosLib 7.3/8.0 Forum
Topic: Get standard Library name
Replies: 8
Views: 451

Re: Get standard Library name

But maybe that's not needed. Afaik it's unnecessary, as GetInstance returns a new instance. As long as there's a plain driver, you'll always get an instance. I did not check the code right now, though so I might be wrong. If anyone is about to add this please make sure that it will continue to work...
by aehimself
10.01.2023, 09:23
Forum: ZeosLib 7.3/8.0 Forum
Topic: Demo version 8 and TransactIsolationLevel
Replies: 6
Views: 728

Re: Demo version 8 and TransactIsolationLevel

I am using it in production since it was still called 7.3 without any major roadblocks. Demos should be the same for Lazarus and Delphi... if you tell us what you would like to do, maybe someone can point you to the demo you are looking for. As for the TZTransaction I can not give an answer as I per...
by aehimself
02.01.2023, 22:20
Forum: ZeosLib 7.3/8.0 Forum
Topic: Get standard Library name
Replies: 8
Views: 451

Re: Get standard Library name

It would also be nice to be able to determine which library is currently being used to see if the correct one is in use. It's actually possible, I even posted it on this forum a while ago. Can not find it atm, so here you go: If Assigned(ZConnection1.DbcConnection) And Assigned(ZConnection1.DbcConn...
by aehimself
16.12.2022, 12:44
Forum: Oracle
Topic: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs
Replies: 13
Views: 1008

LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs

Probably this is going to be a driver issue, as opening the exact same resultset on the exact same machine using the exact same settings, but using OCI 19.8 loads everything perfectly. The new version also loads all data correctly, if LobCacheMode is None. I just would like to leave it here as it se...
by aehimself
19.11.2022, 20:42
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ignoring required fields
Replies: 7
Views: 276

Re: ZMemTable ignoring required fields

Can you check the metadata, if NULLABLE is properly returned and detected by Zeos?
Also, a minimal example would be appreciated so we can check what is going wrong.
by aehimself
27.10.2022, 09:44
Forum: ZeosLib 7.3/8.0 Forum
Topic: Exception in releaseimmediate
Replies: 6
Views: 187

Re: Exception in releaseimmediate

Maybe you don't need to interrupt the network. Check if killing the session is sufficient, this would make testing a lot more easy: https://dataedo.com/kb/query/mysql/kill-session MySQL's current implementation of .AbortOperation is similar: function TZMySQLConnection.AbortOperation: Integer; Var ki...
by aehimself
27.10.2022, 09:25
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ignoring required fields
Replies: 7
Views: 276

Re: ZMemTable ignoring required fields

I saw that Michael took a different approach fixing this, the commit is already in SubVersion . However I don't see the reason for a required check to be implemented 3 different locations (once in TDataSet, once in TZAbstractRODataset and now in TZMemTableResultSet) this solution feels a lot more el...
by aehimself
26.10.2022, 11:44
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ignoring required fields
Replies: 7
Views: 276

Re: ZMemTable ignoring required fields

Does anyone know what this means by the way? This is why inherited isn't called, this is why required fields are simply ignored. //AVZ - Firebird defaults come through when this is commented out Maybe it worth a try to simply call inherited and run it against the tests. I would like that solution be...
by aehimself
26.10.2022, 10:49
Forum: ZeosLib 7.3/8.0 Forum
Topic: Bug #560 not reproducible, please ask for code!
Replies: 1
Views: 132

Bug #560 not reproducible, please ask for code!

I have no SF account so can not post a comment on the bug. https://sourceforge.net/p/zeoslib/tickets/560/ 1, blob.Clear seems to work as intended. ZMemTable1.FieldDefs.Add('ID', ftLargeint, 0, True); ZMemTable1.FieldDefs.Add('Name', ftString, 255, True); ZMemTable1.FieldDefs.Add('Data', ftBlob); ZMe...
by aehimself
26.10.2022, 10:34
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ignoring required fields
Replies: 7
Views: 276

Re: ZMemTable ignoring required fields

Fixed :)

Pull request available on GitHub.
by aehimself
25.09.2022, 09:08
Forum: ZeosLib 7.3/8.0 Forum
Topic: Version ZEOS for Delphi Alexandria
Replies: 1
Views: 318

Re: Version ZEOS for Delphi Alexandria

The latest Zeos8 from SVN or Git works just fine.
If you prefer, you also can try to install 7.2 as well with the latest package available; it might work.
by aehimself
22.09.2022, 08:40
Forum: ZeosLib 7.3/8.0 Forum
Topic: Writing Blobs from Streams Failing in SQLite... SOMETIMES...
Replies: 17
Views: 835

Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...

OMG, this is the most paranoid code I've ever seen... "World state" suggests we are talking about a game engine. Imagine the lag 1,2 sec of saving world state will generate :) Tbh I don't see the reason of this check either. I'd only do safeguards if actual corruption happened once but co...
by aehimself
21.09.2022, 18:20
Forum: ZeosLib 7.3/8.0 Forum
Topic: Writing Blobs from Streams Failing in SQLite... SOMETIMES...
Replies: 17
Views: 835

Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...

This by itself won't do much. - Save the original data to the disk, save the contents of blob field to the disk. Compare the differences. - After saving your blob, post the dataset and read it to a different stream. Save both streams to the disk and compare differences. My guess is your data is safe...
by aehimself
20.09.2022, 20:47
Forum: ZeosLib 7.3/8.0 Forum
Topic: Help translating some subclassed functions from V7.2x to V8
Replies: 3
Views: 116

Re: Help translating some subclassed functions from V7.2x to V8

You'll need something like TZGenericStatementAnalyser and DefineSelectSchemaFromQuery but instead of SELECT and FROM, you'll have to search to DELETE FROM, INSERT INTO and UPDATE SET. Most probably you'll end up with a class helper / derived analyzer. I just wrote one for myself, that's why I know ...