New TZParam/TZParams enabled

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: New TZParam/TZParams enabled

Post by EgonHugeist »

@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 -> mariadb_stmt_execute_direct). Then the value in the strings is "NULL" of course.

But for Oracle and other drivers we use native typed bindings. Means we prepare a structure the provider is able to read, declaring the types and tag the nullability. That than means those drivers, even if NULL, do a strict type check. If the value is bound more than once and not null the buffer contained value should be convertable by provider into it's native format.
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply