There is a property ZConnection.UseMetadata that can be enabled or disable, what is it for?
Is for my application to consume something?
I´am learning about zeo to create this page to help brazilian comunity:
https://gladiston.net.br/?page_id=757
ZConnection.UseMetadata, what is it for?
Re: ZConnection.UseMetadata, what is it for?
Hello,
Fresh from the source:
Just a small heads-up, you mention Zeos 7.3 in your article but that version never officially existed.
Fresh from the source:
Code: Select all
/// <summary>Are metadata used? If <c>True</c> then we can determine if
/// columns are writeable or not. This is required for generating automatic
/// updates.</summary>
/// <returns><c>True</c> if metainformations are turned on; <c>False</c>
/// otherwise.</returns>
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
-
- Platinum Boarder
- Posts: 1962
- Joined: 17.01.2011, 14:17
Re: ZConnection.UseMetadata, what is it for?
Hello,
UseMetadata tells Zeos drivers to not fetch metadata from the database. Some drivers need metadata at some point to get enough information for building insert / update / delete statements. So usually it is best to keep this option enabled. Otherwise Zeos could behave unexpectedly like not being able to determine field types correctly or making all data sets read only. Disabling UseMetadata can help in some rare corner cases.
Best regards,
Jan
UseMetadata tells Zeos drivers to not fetch metadata from the database. Some drivers need metadata at some point to get enough information for building insert / update / delete statements. So usually it is best to keep this option enabled. Otherwise Zeos could behave unexpectedly like not being able to determine field types correctly or making all data sets read only. Disabling UseMetadata can help in some rare corner cases.
Best regards,
Jan
Re: ZConnection.UseMetadata, what is it for?
I fix my article:
https://gladiston.net.br/?page_id=757
More late, I will translate to english.
Thank you guys.
https://gladiston.net.br/?page_id=757
More late, I will translate to english.
Thank you guys.
Re: ZConnection.UseMetadata, what is it for?
Thank you for using, advertising and helping others to be able to use Zeos :)
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47