Search found 38 matches
- 05.06.2021, 23:57
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Best/Right approch for master/Detail
- Replies: 19
- Views: 910
Re: Best/Right approch for master/Detail
LGPL, our code is not open Just a quick question... I'm far away from completely understanding all conditions of licenses (or being a lawyer) but according to LGPL changes made to the original source must be made public, no? we are not modifying the library in any way and not deriving from library ...
- 01.05.2021, 11:50
- Forum: ZeosLib 7.2 Forum
- Topic: TZAbstractDataSet too slow to iterate 7668 rows
- Replies: 11
- Views: 574
Re: TZAbstractDataSet too slow to iterate 7668 rows
if your dataset is TZquery you can iterate over DbcResultSet, s/t like
Code: Select all
with (DataSet as TZQuery).DbcResultSet do
begin
BeforeFirst;
while Next do
begin
GetIntByName('')
end;
end;
- 01.05.2021, 10:54
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Best/Right approch for master/Detail
- Replies: 19
- Views: 910
Re: Best/Right approch for master/Detail
No - what I am saying is that using transactions is better than using the cached updates feature of Zeos. what about starting with his topology and how his users are gonna use his application. Just to make that clear: Connection losses of applications have not been a concern for any of the applicat...
- 01.05.2021, 00:29
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Best/Right approch for master/Detail
- Replies: 19
- Views: 910
Re: Best/Right approch for master/Detail
@marsupilami you are kidding, right? you just telling him to use long-living transactions instead of short ones, maybe on localhost, but on a local network or over the internet it's the worst he can do. believe me, I spend last years rewriting every long transaction to a short one to prevent daily c...
- 11.11.2020, 14:14
- Forum: ZeosLib 7.2 Forum
- Topic: IZPreparedStatement with Blob
- Replies: 1
- Views: 183
Re: IZPreparedStatement with Blob
ResultSet.Next was missing :'(
- 11.11.2020, 12:25
- Forum: ZeosLib 7.2 Forum
- Topic: IZPreparedStatement with Blob
- Replies: 1
- Views: 183
IZPreparedStatement with Blob
i have FILE_STORE external function in FB defined as DECLARE EXTERNAL FUNCTION FILE_STORE BLOB, VARCHAR(300) BY DESCRIPTOR RETURNS INTEGER BY VALUE ENTRY_POINT 'file_store' MODULE_NAME 'storage'; i can call it with TZQuery without problems var Query := TZQuery.Create(nil); Query.Connection := FConne...
- 26.03.2020, 17:40
- Forum: ZeosLib 7.2 Forum
- Topic: ZeosLib can't correctly compare Extended value when creating update query
- Replies: 4
- Views: 318
Re: ZeosLib can't correctly compare Extended value when creating update query
thx for info, will switch to TBCDFields in future
- 25.03.2020, 17:43
- Forum: ZeosLib 7.2 Forum
- Topic: ZeosLib can't correctly compare Extended value when creating update query
- Replies: 4
- Views: 318
Re: ZeosLib can't correctly compare Extended value when creating update query
it's definitely regression, you can't compare two floats this way, https://floating-point-gui.de/errors/comparison/ just load some decimal number to the dataset, update dataset without changes (Edit and Post) and zeos will create update query that contains your decimal field even field not changed. ...
- 20.03.2020, 14:25
- Forum: ZeosLib 7.2 Forum
- Topic: ZeosLib can't correctly compare Extended value when creating update query
- Replies: 4
- Views: 318
ZeosLib can't correctly compare Extended value when creating update query
CompareExtended_Equals from ZDbcCache will return an incorrect result for the "same" numbers
- 14.05.2019, 10:29
- Forum: ZeosLib 7.2 Forum
- Topic: Type mismatch for field 'xx' expecting: Float actual Extended
- Replies: 5
- Views: 1304
Re: Type mismatch for field 'xx' expecting: Float actual Extended
when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week
- 10.05.2019, 13:01
- Forum: ZeosLib 7.2 Forum
- Topic: Type mismatch for field 'xx' expecting: Float actual Extended
- Replies: 5
- Views: 1304
Type mismatch for field 'xx' expecting: Float actual Extended
after updating to current 7.2 patches I'm getting Type mismatch for field 'xx' expecting: Float actual Extended for all NUMERIC( 18, 4) fields Firebird 3.5
should I go back to stable version or fix these exceptions but how?
should I go back to stable version or fix these exceptions but how?
- 26.09.2018, 08:39
- Forum: ZeosLib 7.2 Forum
- Topic: FB create new database regression
- Replies: 1
- Views: 1255
FB create new database regression
There is regression between 7.2.3/4 and patches-7.2 when creating new DB in FB 2.5+/3.0.x Connection := CreateConnection() Connection.Properties.Add('CreateNewDatabase=CREATE DATABASE ... Connection.Connect; // will create db Connection.Properties.Clear; Connection.Reconnect //in patches-7.2 logic c...
- 07.08.2018, 14:49
- Forum: ZeosLib 7.2 Forum
- Topic: ReadOnly Field
- Replies: 2
- Views: 881
Re: ReadOnly Field
i resolved it by manually setting ReadOnly to False
Code: Select all
Field.ReadOnly := False;
Field.Value := Value;
DataSet.Post;
- 07.08.2018, 13:25
- Forum: ZeosLib 7.2 Forum
- Topic: ReadOnly Field
- Replies: 2
- Views: 881
ReadOnly Field
i have regression from 7.1 for firebird 2.5 (FB 3.x is ok) im feeding dataset from complex query and for firebird 2.5 fields are set As ReadOnly = true and i'm getting Field 'my_field' cannot be modified it's part of a bit complex system that is automatically loading and applying changes load actual...
- 09.07.2018, 07:20
- Forum: ZeosLib 7.2 Forum
- Topic: FB random Invalid BLOB ID
- Replies: 5
- Views: 1603
Re: FB random Invalid BLOB ID
i'ts not fixed by r4715 (i'm testing just 7.2-patches branch), i'll try to create small demo for you EDIT: seems i can't create simple demo, it looks like its some kind of error in Firebird... Edit2: im trying to bisect it FB 3.0.4 will return error, FB 3.0.3 returns some wrong data see attachments ...