Zeoslib Portal

Norbert, thanks for the feedback even if i had no time to reply. As aehimself notice ... what a *beep*
Could you point the developers to the Zeos8 TZParams? That would help you and others!

Hello Michl, thanks for the detailed infos. I have fixed the bug on Zeos side, see r7388: https://sourceforge.net/p/zeoslib/code-0/7388/ . OTH it's definitelly a bug on FPC side too. Scale(SignSpecialPlaces) can't be greater than precision. Thus i would argue FPC FormatBCD is correct implemented whe...

Hi Bruno, your are faster on testing than me on announcing the features. Bruno i'll check your examples. The FB exception should not be thrown. Thus i accapt the ticket. What i miss in your code is: Query/Table.FetchAll That's why the property starts with "Try". I still think it's not a go...

Hi Mark, glad i could help even if the patch is not correct @all as you pointed out. Missing things are: 1 Timestamp offset is changing whan a user sets the offsets manualy as you've done it. 2 The offset also dependeds to sommer/winter time. Here in germany we've a UTC offset of +2 in sommer-time a...

Hi Mark, what the hell..! First of all: There are no tests for this situation available in our test-suite. If they would exist i wouldn't set the binary-wire as default for PG. Yes you are right the posgres docs descibe this behavior complete different: https://www.postgresql.org/docs/9.1/datatype-d...

Thx Mark for the feedback.

The patch is applied see: https://sourceforge.net/p/zeoslib/code-0/7355/

#1: I removed the scan.
#2: Done as suggested.
#3: that should never happen!
#4: Case closed?

Any other remarks,hints or suggestions?

Any news on this, Mark?

Hi, i'm not willing to fix or replace the FPC FormatBCD method. But i did override the SetAsLargeInt/SetAsCurrency methods in the TZFMTBCDField. I'm always leftpacking the values. So test https://sourceforge.net/p/zeoslib/code-0/7317/ . Did that help? Just a hint: remove the display format. To be fa...

Thanks for the feedback! Keep the connection on only until you need it. That's it Man!!! :D Are you using Delphi or Lazarus? Both of them, Delphi 2010 and Lazarus 2.0.10. I'll chek what going on if a connection is assigned. What I'm wondering is, if it's possible to persist changes made in ZMemTable...

Does it need one? Or it'll be optional? In my view the main advantage of a memtable that it is 100% functional without a connection and therefore can be used to de- and reconstruct data tables from any source. No it does not "need" a connection. I just added it to inherit the ControlsCode...

Hello tintinux, i hade a look to Classes.pas of FPC3.2. They added an overload for loadfromstream/loadfromfile having a TEncoding overload. Whithout checking your example it feels correct to add this parameter to our TSQLProcessor.LoadFrom(File/Stream). See https://sourceforge.net/p/zeoslib/code-0/7...

Thanks for the feedback! As my commit says: it was a 20 min job :P I found some more inconsistencies in other components too TZStoredProc has an UpdatSQL property TZStoredProc has no Transaction property TZStoredProc has OnPostError Event property TZMemTable has an UpdatSQL property TZMemTable has O...

@ Michael, I can confirm that your fix works, the test and the original query runs fine now. With 2 parameters I can see 3 binds - which was my original idea. There are two thing what bugs me: - Checking the code change I still have no damn clue what you did. Well, you know the code and I don't... ...

What I've seen so far looks very good, nice job! Thank you. I found some AV's so please update again. I had several approaches ... The committed one was the most simple as possible one for the users, i guess. Mark as annouced i removed the AdjustSecondFractionsFormat property in the TZTimeField/TZD...

Hello Mark,
I'm working on it. I will change the logic again and implement some format-setting classes for the Connection+DataSet+Field. That should make live for user easier. Yet i'm not ready. Just FVI