Search found 24 matches

by zoltan
12.01.2022, 11:30
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
15.12.2021, 14:33
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
15.12.2021, 10:25
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
13.12.2021, 16:13
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
08.12.2021, 14:14
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
05.12.2021, 10:55
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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
by zoltan
02.12.2021, 14:08
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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
by zoltan
29.11.2021, 12:11
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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
by zoltan
25.11.2021, 14:39
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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.
by zoltan
25.11.2021, 14:37
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
25.11.2021, 09:44
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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.
by zoltan
23.11.2021, 10:11
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
08.07.2021, 14:53
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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: ----------------------------------------------------------------------------------------------------------------------------------------------------...
by zoltan
09.04.2021, 11:24
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...
by zoltan
07.04.2021, 14:21
Forum: Oracle
Topic: Datetime paramtere and Union all problem
Replies: 46
Views: 3076

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...