Search found 1934 matches

by EgonHugeist
12.07.2020, 18:26
Forum: ZeosLib 7.3/8.0 Forum
Topic: How to handle transactions properly with Zeos?
Replies: 19
Views: 3097

Re: How to handle transactions properly with Zeos?

I'll start a new topic about.(if i would have time ...sigh). Then let's discuss about. Or do it by you selves and ask for purpose.. It's not related to your topic. Just some interesting links: https://dba.stackexchange.com/questions/177663/performance-tuning-for-mysql-database-read-only https://ib-a...
by EgonHugeist
11.07.2020, 07:13
Forum: ZeosLib 7.3/8.0 Forum
Topic: How to handle transactions properly with Zeos?
Replies: 19
Views: 3097

Re: How to handle transactions properly with Zeos?

This is tricky question... I haven't yet figured it out completely myself. The catch is that there's no separate transaction object in Zeos. It's tied to connection (so you can't do nested transactions - though probably I'm wrong here). TZTransaction added on 7.3-testing. TZDataSet has UpdateTransa...
by EgonHugeist
11.07.2020, 07:05
Forum: ZeosLib 7.2 Forum
Topic: Oracle 12.2.0.1 keeps throwing ORA-01406
Replies: 25
Views: 4989

Re: Oracle 12.2.0.1 keeps throwing ORA-01406

I did not know about this but this makes sense. What is really strange in this case is that I receive the exact same message when the ClientCodePage is set to AL32UTF8 (AL32UTF16 crashes with TNS protocol error, AL32UTF32 :)) characterset 'UTF16' of oracle should be supported on 7.3 inbetween, have...
by EgonHugeist
11.07.2020, 06:57
Forum: ZeosLib 7.3/8.0 Forum
Topic: List of connection properties?
Replies: 36
Views: 2594

Re: List of connection properties?

@Fr0st, Btw, very good way to check correctness of Zeos hierarchy is to rename both dbc and component source folders, comment out ZTestDbc/ZTestComponents in test project and try to build it. Then uncomment dbc and build. Hope it's done already.. I can't get why TZClientVariantManager was moved, it ...
by EgonHugeist
11.07.2020, 06:49
Forum: ZeosLib 7.3/8.0 Forum
Topic: Transaction differences
Replies: 9
Views: 476

Re: Transaction differences

@aehimself
Setting AutoCommit to false isn't required anymore, doing that means restart the txn after each commit/rollback while connected..

@Jan could you plz add a minimal test?
by EgonHugeist
10.06.2020, 06:31
Forum: Oracle
Topic: oracle execute anonymous block with ptOutput parameter
Replies: 3
Views: 4333

Re: oracle execute anonymous block with ptOutput parameter

Hello volkerp,
that's supported since 7.3 and up.. Any feedback is welcome. Have fun.
by EgonHugeist
10.06.2020, 06:22
Forum: Oracle
Topic: ORACLE and RIO10.3.3 Problem with SELECT-Statement
Replies: 12
Views: 1235

Re: ORACLE and RIO10.3.3 Problem with SELECT-Statement

Hello Chris, looking to your details, i would start from the premisse the LibraryLoader did found a 'oci.dll' on your system which as same bitness but is not a oracle-client OCI.DLL. Track my suggestion by using the LibraryLocation manuallly(add full path and lib-name) if the error went away, check ...
by EgonHugeist
10.06.2020, 06:13
Forum: ZeosLib 7.3/8.0 Forum
Topic: How to handle transactions properly with Zeos?
Replies: 19
Views: 3097

Re: How to handle transactions properly with Zeos?

Arrrm i do interpret the general question a bit differently. It's not about ApplyUpdates only. To be honest the ticket was for nested txn's only. Thinking about your question brings different things to my mind: we need a txn stack in the cached-resultsets. Assume we've a txn-level > 1 If a commit is...
by EgonHugeist
10.06.2020, 06:04
Forum: ZeosLib 7.3/8.0 Forum
Topic: Fancy bitmap still does not show up on Delphi splash screen
Replies: 1
Views: 122

Re: Fancy bitmap still does not show up on Delphi splash screen

Jup, there is the bitmap missing in the ZComponentDesgn.res, i think. Have a look to Pitfiend's code in ZComponentReg.pas.
I think we need to load the bitmap (artwork\ZeosLibSplash.bmp) into the resource file and try to load it. Am i right? Never had time todo that, sorry.
by EgonHugeist
10.05.2020, 11:51
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZTable/ZQuery with persistent fields broken
Replies: 6
Views: 320

Re: ZTable/ZQuery with persistent fields broken

@abonic. Hope i got it, please update from SVN \7.3-Testing and report your findings..
by EgonHugeist
10.05.2020, 11:50
Forum: ZeosLib 7.3/8.0 Forum
Topic: In Lazarus 2.0.6 DBGrid display format ,0.00;-,0.00;
Replies: 17
Views: 1075

Re: In Lazarus 2.0.6 DBGrid display format ,0.00;-,0.00;

@ribut no rolling back to 7.2 shouldn't be an option. Your first choice should be file a bugreport to FPC bugtracker. Others may run into same issue. Your syntax is very rare and i didn't know it before. The difference between 7.2 and 7.4 for you is 7.3 is unsing the FmtBCD fields while 7.2 uses the...
by EgonHugeist
06.05.2020, 16:11
Forum: ZeosLib 7.3/8.0 Forum
Topic: External:SIGSEGV ZAbstractRODtaset.pas Line 4978
Replies: 5
Views: 426

Re: External:SIGSEGV ZAbstractRODtaset.pas Line 4978

Ping.. Please answer Jan questions if you expect support.
by EgonHugeist
06.05.2020, 16:10
Forum: ZeosLib 7.3/8.0 Forum
Topic: In Lazarus 2.0.6 DBGrid display format ,0.00;-,0.00;
Replies: 17
Views: 1075

Re: In Lazarus 2.0.6 DBGrid display format ,0.00;-,0.00;

Hello ribut, first i did not understand the proplem but testing it with delphi... your testcase works with all knonw delphi compilers we support except fpc.. There is a bug in FormatBCD() of FPC (we replaced CompareBCD(buggy), DoubleToBCD(buggy), CurrencyToBCD(slow) already ) I must admit replacing ...