Search found 1934 matches
- 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...
- 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...
- 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...
- 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 ...
- 11.07.2020, 06:50
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How hard it is to implement a new event in TZSQLMonitor?
- Replies: 26
- Views: 1260
Re: How hard it is to implement a new event in TZSQLMonitor?
@aehimself
any progress about tread toppic?
any progress about tread toppic?
- 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?
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?
- 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.
that's supported since 7.3 and up.. Any feedback is welcome. Have fun.
- 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 ...
- 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...
- 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.
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.
- 10.06.2020, 06:01
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Query.CachedUpdates := False is attempting to double-apply
- Replies: 10
- Views: 476
Re: Query.CachedUpdates := False is attempting to double-apply
Create job, thx!
- 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..
- 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...
- 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.
- 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 ...