Search found 38 matches

by DPStano
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 ...
by DPStano
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;
by DPStano
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...
by DPStano
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...
by DPStano
11.11.2020, 14:14
Forum: ZeosLib 7.2 Forum
Topic: IZPreparedStatement with Blob
Replies: 1
Views: 183

Re: IZPreparedStatement with Blob

[solved] ResultSet.Next was missing :'(
by DPStano
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...
by DPStano
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. ...
by DPStano
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
by DPStano
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
by DPStano
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?
by DPStano
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...
by DPStano
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;
by DPStano
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...
by DPStano
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 ...