Hi Michal,
seems to be OK.
Thanks for your advice.
Best regards
Chris
ZEOS Version 7.1.4-Stable
ORACLE 11.2.0.1
Delphi 2010
Christoph Wiwie
http://www.wiwie.de
Certified Tester/ Certified Requirements Engineer
Search found 7 matches
- 10.03.2015, 11:15
- Forum: ZeosLib 7.1 stable Forum
- Topic: Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)
- Replies: 2
- Views: 976
- 06.03.2015, 22:01
- Forum: ZeosLib 7.2 Forum
- Topic: Range check error
- Replies: 7
- Views: 2643
Re: Range check error
Hallo, I ran into the same error (Use code ZEOS 7.2 svn Revision 3619 with D2010). I think you found another example of a more general problem (See my postings in the 7.1.4-stable Forum). The point is that the compiler range checkings are switched OFF when the ZEOS-source is compiled and the compone...
- 05.03.2015, 11:11
- Forum: ZeosLib 7.1 stable Forum
- Topic: Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)
- Replies: 2
- Views: 976
Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)
Hallo @All I'am facing a strange performance problem (ORACLE) with ZEOS 7.1.4 My test-setup: * Have an ORACLE-table "MyTable" with 154 columns including over ten varchar2(200) columns (2000000 records) * "MyTable_INDEX" is a unique index on a NUMBER-column * Use TZQuery in ReadOn...
- 23.02.2015, 10:48
- Forum: ZeosLib 7.1 stable Forum
- Topic: Runtime-Error during (ORACLE) Unicode data selection (with activated D2010 Compiler Range-Check/Overflow checking)
- Replies: 0
- Views: 784
Runtime-Error during (ORACLE) Unicode data selection (with activated D2010 Compiler Range-Check/Overflow checking)
Hallo @All With D2010 activated range checking reading NULL -values from UNICODE columns causes a runtime error. My Test-Setup: * Have an ORACLE-Table "XY" with VARCHAR-column containing NULL-values * Add "ZEncoding.pas" (for debugging) to my project. * Activate Range checking an...
- 22.02.2015, 19:19
- Forum: ZeosLib 7.1 stable Forum
- Topic: Runtime-Error during ORACLE data selection (with activated D2010 Compiler Range-Check/Overflow checking)
- Replies: 0
- Views: 663
Runtime-Error during ORACLE data selection (with activated D2010 Compiler Range-Check/Overflow checking)
Hallo @All it seems that ORACLE-metadata are interpreted wrongly in some circumstances. My test-setup: * Have an ORACLE-table "XY" with "ColumnNameXY NUMBER(2)" * Activate range checking and overflow checking in the D2010 compiler * Make a select from table "XY" * Run i...
- 27.05.2014, 12:07
- Forum: 6.6 - stable
- Topic: windows 7 - SQLHourGlass - SLOW
- Replies: 12
- Views: 5919
Re: windows 7 - SQLHourGlass - SLOW
Hallo @All some observations regarding that issue: * The issue seems to persist in the 7.1.3stable code * Win7 32/64 Bit OS seems to be not the core reason (On a Win7 Home Premuim it "runs", on a Win7 Prof it "does not"). * In our environment setting SQLHourGlass to FALSE and set...
- 08.05.2014, 16:05
- Forum: ZeosLib 7.1 stable Forum
- Topic: Problem Updating NON-Cached ORACLE-Records
- Replies: 0
- Views: 1092
Problem Updating NON-Cached ORACLE-Records
Hallo @All there seems to be a problem retrieving the name of the Primary Key in an ORACLE environment. In the current implementation the Index name is retrieved by: Select ... FROM FROM ALL_INDEXES A, ALL_IND_COLUMNS B WHERE .... AND A.UNIQUENESS='UNIQUE' AND A.GENERATED=''Y''' AND A.INDEX_NAME LIK...