Zeoslib Portal

Hi ALL, New job here, I need to migrate old dababase MSSQL 6.5 w/ BDE+Delphi7 to FirebirdSQL/Lazarus. Old Delphi use BDE w/ SQL Links to access MSSQL version 6.5 with several stored procedures, it´s run fine because BDE use C:\MSSQL\BINN\ntwdblib.dll directly to talk. But in my tests, Zeos not. I tr...

I tried several times but it does not recognize fields on second datasource(detail).
There is a secret to use :field_datasource2?

Still studing zeoslib, now zquery. I would like a help, I am not understanding datasource property in zquery component. To me I can reference a field in another dataset and maybe in another connection, but I can't find any doc about. I know that is not for use master/detail 'cause I have masterdatas...

Thanks Jan, I think the same.

Now I am writting about zquery and I found this property "ShowRecordTypes", that I not found any doc via google, except this: https://lazarus.intern.ws/zeos_zquery.html but none explanation. I think that is similar a firedac to extract "delta" before commit updates, is it the sam...

Thanks to help me.

When SQLHourglass is true, where an SQL command is currently 'SQL Client, it will be an hourglass with the initials SQL. Is this because Zeos changes the appearance or is the 'SQL Client' doing this?

Hi Michael,

Well, I fix some improvements in my article to serve both versions.
In the future, I will translate to english.

Is it possible to change TIL without reconect a database? Using zeos 7.2 without reconnect changing properties: isc_tpb_concurrency, isc_tpb_nowait, isc_tpb_read, isc_tpb_write, isc_tpb_consistency, isc_tpb_read_committed, isc_tpb_rec_version does not have any affect until disconect and reconect. Is...

Thank you.
With your help, now my article are more complete:
https://gladiston.net.br/usando-zeos-co ... onnection/

Hi guys again. I would like to know how is does work autocommit property in ZConnection. When autocommit:= true, I can start a transaction, but when is false I can´t and there is already transaction started. I was believe that each sentence DSQL will be commited without need a formal start transacti...

I fix my article:
https://gladiston.net.br/?page_id=757

More late, I will translate to english.
Thank you guys.

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

It´s clear now.
Thank you very much.

Hi devs, I would like to know when I need AutoEncodeStrings enabled or disabled? I keep searching but I can find about. Can someone patient explain to me? In Databases like FirebirdSQL generally I use charset ISO8859_1, is it right AutoEncodeStrings disabled? I think that I need to use AutoEncodeStr...