Search found 24 matches
- 12.01.2022, 11:30
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
@marsupilami, @aehimself Guys You have done a wonderful work! THANK YOU very much! I have downloaded the latest version from github, and it seems to be working perfectly! All problems are vanished, all querries seems to be working perfectly! Even my old problem is solved: if I asked for the length o...
- 15.12.2021, 14:33
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Thank You Jan very much for the BeginUpdate / EndUpdate explanation! Until now I never had time problems, but now I will pay attention. I heard about SQL injection attacks, but luckily until never met such problem, hopefully I never will :) Tested that little sql : 'select ' ' from dual'. Just by it...
- 15.12.2021, 10:25
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Sorry to bother You with this, I have never used it, but what the usefullness of BeginUpdate / EndUpdate procedures ? I always used Open / Close or ExecSQL. They were totally enough for me. I never had speed problems or any other problems this way. Nowadays I was thinking about not using :xxxx style...
- 13.12.2021, 16:13
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
@marsupilami: I have tried this little SQL, even a little bit more, but I could not produce the error. But in my test program I can reproduce... This I dont understand... @aehimself: like to write the sql in this form, because this way I can see everything well. This sql is one of the simpliest ones...
- 08.12.2021, 14:14
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Ok... then here it is, I can reproduce it anytime. Lets have the following SQL: -------------------------------------------------------------------------------------------------------------------------------------------------- { 1} ZO1F.SQLQuery1.SQL.Add(' select SubStr(b.bemerkung,1,50) as bemerkun...
- 05.12.2021, 10:55
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Ok, understood... I will test the SubVersion download and return with the result
Meantime I found another problem with Oracle interface but first I will test with the version 8 from SVN.
Thank You very much for Yorur time and help!
Zoltttan
Meantime I found another problem with Oracle interface but first I will test with the version 8 from SVN.
Thank You very much for Yorur time and help!
Zoltttan
- 02.12.2021, 14:08
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Is this the last version of Zeos 8.0 :
https://github.com/marsupilami79/zeoslib
Sorry, I never downloaded from here, I always used the ZIP file
Many Thanks for Your help!
Zoltan
https://github.com/marsupilami79/zeoslib
Sorry, I never downloaded from here, I always used the ZIP file
Many Thanks for Your help!
Zoltan
- 29.11.2021, 12:11
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Wow... this means that in the actual ZeosLib Stable 7.2.14 it already contains the patch ? If yes, then I will install into Lazarus.
Btw... Can You tell me please that a stable version of ZeosLib 8.x when migth be expected ?
Thank You!
Zoltán
Btw... Can You tell me please that a stable version of ZeosLib 8.x when migth be expected ?
Thank You!
Zoltán
- 25.11.2021, 14:39
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Now I have checked, that I am using an old Zeos version, 7.2.10 from April, 2021.
- 25.11.2021, 14:37
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Ok, used SQLMonitor and got the following log : --------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2021-11-25 14:31:09 cat: Connect, proto: oracle-9i, msg: CONNECT TO "ETN03DB.prod...
- 25.11.2021, 09:44
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Ok, I will put SQLMonitor and send the log.
Using ZeosLib connection I got no error message. I got error message using Lazarus built-in OracleConnection object.
Using ZeosLib connection I got no error message. I got error message using Lazarus built-in OracleConnection object.
- 23.11.2021, 10:11
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Hi! It seems to me that I found an error in the Zeoslib Oracle library. Let's take my original SQL: ---------------------------------------------------------------------------------------------------- select SubStr(b.bemerkung,1,50) as bemerkung, t.tnre, SubStr(t.bez,1,25) as Megnevezes, To_Char(b.m...
- 08.07.2021, 14:53
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
It's ok, I just signaled the mismatch, basically I dont care. Ok... So since Your last post some more problems came upon, so I wrote a little software: ----------------------------------------------------------------------------------------------------------------------------------------------------...
- 09.04.2021, 11:24
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Michal, I have installed version 7.2.10-stable from Your website. It works much better then version 7.2.8, but it still has this timing problem. Note: when I wanted to install this 7.2.10 version, Lazarus showed me version 7.2.8. I checked in the lpk file and the version numbers are 7.2.8 Is this in...
- 07.04.2021, 14:21
- Forum: Oracle
- Topic: Datetime paramtere and Union all problem
- Replies: 46
- Views: 3635
Re: Datetime paramtere and Union all problem
Ok, I understand, then I will install = build into Lazarus the latest 7.2.xx version and try to get around the Oracle problems. About Lazarus, Jan said that actually it's no need to re-install Lazarus, because the compiler is the same. I also don't thinkk that I should totally re-build my whole Laza...