Zeoslib Portal

I'm asking because after https://sourceforge.net/p/zeoslib/code-0/6728/ my logs are looking like: '2020-07-23 06:07:25.491' cat: Prepare, proto: sqlite, msg: Statement 4 : PRAGMA table_info('Orders') '2020-07-23 06:07:25.491' cat: Execute prepared, proto: sqlite, msg: Statement 4, elapsed time: '00:...

P.s.: would you please remove / mask that SELECT query in your post? Which one? :oops: Sry :censored: Why not to load fields with .AsBytes? They do not support it...? Nope, i don't know why, did you ever test it? Look to my code, there are conversions included. However it would be nice to find the ...

Ok, it took me an half hour to port your example. Sadly there is no regression to see. As you wrote there is just plain ANSI used. So let's find diffs: My oracle client version exacly matches the host version. Yours: Server is Oracle 11.2.0 and client library is 12.2.0. does not match. While trying ...

Fixed as proposed. Thx for pointing this out.
Btw. is the elapsed time available in the logs?

Done in SVN on 7.3-testing Implementing the "affected row(s)" was simple, implementing "retunred row(s)" was a bit more work. Looking to your current log iv'e been trying to reduce the number of duplicate logs. Note i don't use it. It's a performance loss logging the request (-> ...

Jan i didn't know that option. Made a quick test: /// <see cref: String> </see> /// <summary> /// Format to read date & time, like YYYY-MM-DD HH:NN:SS.F /// </summary> /// <remarks> /// Just simple formats are supported. ISO 8601 is prefered. /// If the driver(f.e. SQLite) supports the 'T' delim...

If there is no other way around.. yes. But write a guide how i can restore the dump. I never did that with Oracle.. The more i need to know what exacly i've todo to reproduce it. Oth: plz consider the "zeosbugtemplate" app of AVZ in your ..\zeosbugtemplate\ folder. Add a small create scrip...

@aehimself i had a look to your work. You did invest a loads of time! To be honest i downloaded it twice, i remember to see it already. Why i didn't apply the code: You ListBox seems to have two columns. D7 dosn't support it. Also was it to Windows spezialized. That than means it's not portable for ...

I found some more missing conversions and did add all of them in https://sourceforge.net/p/zeoslib/code-0/6716/

Hi, what ever i'm doing i can't reproduce the truncation error.

Could you please make a minimal demo-app to reproduce it?

Sergio, could you switch to 7.3? The explicit oracle types are messy. Do you really need them? OTH 7.3 should support what you need, am i wrong?

Thanks, we are doing some performance measurement with external frameworks like mORMot. And using "UTF16" instead of "AL32UTF8" pimps the whole Oracle performance by 10% in avg for all character columns. So knowing you database and setting the correct ClientCharset before connect...

My POV: Yes i use it for production a long time. Loads of things did change and our change-list is not complete yet.
So don't hassitat to test, you're welcome. Report problems in the forum and you'll get support by users or members...

An explizit [TZConnection|TZTransaction].StartTransaction/[Commit/Rollback] is sufficient. That way you save some roundtrips. To be clear: State of TZConnection.AutoCoomit = True; TZConnection.StartTransaction -> start an explicit txn(sets the AutoCommit property to False) Do something.. Do somethin...

Not a problem, just wanted to know about grogress. It make no sence if i quickly add it, if you started already...