Zeoslib Portal

Thoughts: It would be nice to omit the ZDBcBeginnerStatement unit. It just re implements the old 7.2 logic. Jan did use it because he oftenly is switching between 7.2 and Zeos 8. It's time to remove the unit. The should not be part of Zeos8. I've added a TZBeginnerPreparedStatement class in ZDbcStat...

Hello Norbert,
Look @ viewtopic.php?f=50&t=129484
you can use the conditional define as a workaround.

Anyway it would be nice to know if the value could be read correctly if we're on same bandwith..

@aehimself, sorry for the delay. I'm bussy with Marks timestamps and other work. Just some tests: procedure TZTestDbcOracleBugReport.TestDuplicateParamNames; var Statement: IZPreparedStatement; ResultSet: IZResultSet; begin Check(Connection <> nil); try Statement := Connection.PrepareStatement('SELE...

aehimself looking to the stacktrace.. I think there is a general design problem in what you're doing i guess. Why is there an FetchAll called while you wanna kill the fetches dynamic? Shouldn't you add an event to the dataset and test if it was signaled? I.e. While not Aborted do DataSet.Next ? IIRC...

That's definitelly related. So please update from SVN and report your findings, eversun.

That was was i was thinking about https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=132042 Same propably whill happen to Posgres too if (not default) someone enables the string-resultset. According your issue: Zeos uses the TZMySQL_Store_ResultSet as native resultset by default. The defaults f...

I made a compare to what i said: 1. assign param by index as it's implemented since ages. That is wrong! Looking to DB.pas: procedure TParams.AssignValues(Value: TParams); var I: Integer; P: TParam; begin for I := 0 to Value.Count - 1 do begin P := FindParam(Value[I].Name); if P <> nil then P.Assign...

ae, according the AV: Should be resolved. Thanks for pointing this out. @Jan According your pull request(s): Please do not apply the patches yet. I've been testing it and we've to many fails then. Guys check https://sourceforge.net/p/zeoslib/tickets/469/ The ticket of Jan is resolved but i totaly ag...

@Norbert,

sounds realy weird. Any new informations?

@eversun please update again. According the report: My crystal ball doesn't tell me what your doing and what you are using for. Thus please provide: 1: Compiler including version 2: Which postgres version? 3: The SQL or bette a little test-case. Otherwise i'll close the ticket. With this information...

@brick08 all values having a precision of 18 and decimals <> 4 can't be represented as BCD(binary coded decimal alias System.Currency). Reason is simple because the Currency is a Int64 having a fixed scale of 4. Means a values with a Scale of 5 f.e. can't fit into the Currency whithout precision los...

Hi ae,
thanks for sharing your code. I quickly did check it and IIRC you're using the ZPropertiesEditor.pas. I was looking for an Parser of ZDbcProperties.pas sry. So it's not helpful 4me but propably for others who want todo slt you're doing.

Hello Gerhard, have a look @ https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=129484 See also new LoadFromFile/LoadFromStream overloads has been added. and the old ones are tagged as deprecated(encoding inconsistent). Reason was to help uses with all the db encoding quirk. Each of the new ove...

Nice! I agree with the XML documentation, but... how exactly you imagined reading out XML comments runtime, especially if the source file is not available? yeh we had that already. You are right. So the easiest way should be a smart tool to generate the Properties for the designtime editors from the...

Hello hoedlmoser,
i finally was able to fix the described issue by https://sourceforge.net/p/zeoslib/code-0/7180/
Note FreeTDS it's self tags all columns as "variable", which is a bug from my POV. But with the metadata in conjunction the fixed/variable types should be seen corectly now.