Zeoslib Portal

Hello MaksymK & welcome to the forum.

Thanks for reporting and the nice test. I was able to resolve your testcase. See https://sourceforge.net/p/zeoslib/tickets/467.

So please update from Trunk and report your findings.

@aehimself of course vtNull variant represents SQL NULL. But there are driver differences: you use the Old FreeTDS DBLIB API and MySQL. For FreeTDS we still send composed SQL-strings instead of native ParamData. For MySQL we do the same in Non-prepared mode(this may change for MariaDB in future -> m...

IMO all parameters need to be typed. You can achieve a "typed" param by setting the type. Example: TZParam(MyParam).SQLType := stBoolean or MyParam.DataType := ftBoolean; If a param is untyped then the first assignment like your ZQuery.ParamByName('pDateTimeNow').AsDateTime := Now; sets th...

@Jan seems correct. I just thought about SQL Server: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15 Escape: [_] or [%] this syntax is known on any Sybase too. But if a server does'nt support it.. We need the escape syntax,...

Don't make it so complicated. It's just dblib which uses this syntax. Use StripEscape instead and test with HasNoWildCards if a like or equal search needs to be made...

Hi, I am trying to enumerate all the useable properties with a program from ZPropertiesEditor. Sound dangerous to me. The properties (yet) are not complete or some may be omitted. Example: Yesterday morning i discovered the method: IZStatement.SetQueryTimeout. Yet u use the query-timeouts as paramet...

Erm - I disagree. As long as there is no Exception to be transported HResult will be S_OK and so @CheckAutoResult doesn't get called. So in a usual use case, there is a maximum of one more integer comparision combined with a jump. For me this hardly is a performance penalty. I seem to remember that...

@Mark,

do it -> #2. Why i was voting for #1 because of keeping backward compatibility for users who are using the TZSQLMetadata components. Now we're on Beta 8, so i've no objection if we go this route!
@Jan please document it..

Thanks for confirmation. Note: If YOU did'nt change anything in your code which may produce a leak, usually the problem is part of an update. I do my best to finalize Zeos8 but as you know: changing a line (in your case 6.000) sometimes an mistake is shipped whith. Only if i and others would stop th...

Mark, the question is correct. Thoughts: if the format has a fraction indicator(ie. '.'/dot) then the fractions should be displayed as: if the fraction part is shorter than the left fractional part the minimal fractions should be displayed. Example: Format is: "....HH:NN:SS.F/Z" and NanoFr...

@Mark, do you know this: https://dev.mysql.com/worklog/task/?id=942 means it's technicaly possible MySQL will change the "SCHEMA"/"CATALOG" purpose. There are more than 1 ticket for the MySQL interpretion of what a schema is... #1: Return "database" in CATALOG and nothi...

@aehimself,

it was my fault. Initializing a Variant for a function result using FillChar() did produce the leaks. Using VarClear() instead did fix it. Can you confirm it? Also did i shorten the code by 1000 lines.

There is a significant difference in how these are handling their values and TZParam sometimes leaks a UnicodeString in my application. Hmm my tests passing fine without memoryleaks. he solution would be to change the COMPLETE way I'm saving parameter values or to roll back to standard TParams... G...

I don't have a XE10.4.
Can you list/publish all warnings please?

Hello, i added the new TZParam component and it TZParams collection. This is done to make my promisse true, that the z8-Series should also support Array BATCH-DML bindings and Component-Layer, which is suported by DBC since years. The TZParam offers all native types Zeos supports, and doesn't care a...