Zeoslib Portal

Hi, In lookup Field, if LookupKeyFields Field Type differs of LookupResultField Field Type I have the error in subject (in the test project: TSmallIntField vs TWideStringField). If Field Type are the same (TWideStringField vs TWideStringField), no errors occur! I attack a test project. There a solut...

delphi2pk wrote:Before applying updateds disablecontrols from both queries and enable it again after comitting.

Thanks a lot, seems to work correctly.

louis wrote:Can Someone explain me, please?

I learn on this tutorial http://zeos.firmos.at/kb.php?mode=article&k=12:

If this option is set then the resultset of the detail is only refreshed when post is called or a record changes (both within master DataSet)

louis wrote:What is the correct usage of Foreign Key on ZeosLib?

I used correctly but the is a bug on Master/Detail that losts detail on applyUpdates, see http://zeosbugs.firmos.at/view.php?id=185

Hallo,
from long time there is a bug on master/detail that losts detail, view at http://zeosbugs.firmos.at/view.php?id=185
Someone use master/detail?
Which workaround uses?
Thanks.

I seem to have solved the problem by reversing the instructions above with what follows: ZQuery1.OnBeforePost: <-- Master begin ZQuery3.ApplayUpdates; <--SubDetail ZQuery2.ApplayUpdates; <-- Detail end; I add Foreign key constraint on Detail referring to primary key on Master. Now when I try ZQuery...

Hallo, I have this scenario: Master-Detail Master have CachedUpdates = False Detail Have CachedUpdate = True On Master.BeforePost I do Detail.ApplyUpdates and works Ok. I tried to understand usage of Foreign key and I add a Foreign Key on table Detail that refer on primary key of Master. But, now wh...

Hallo,
I use FB 2.1.
I try to understand what is doAlwaysDetailResync Options.

Can Someone explain me, please?

Thanks

I applay Updates on ZQuery1.BeforePost: ZQuery2.ApplayUpdates and ZQuery3.ApplayUpdates. I seem to have solved the problem by reversing the instructions above with what follows: ZQuery1.OnBeforePost: <-- Master begin ZQuery3.ApplayUpdates; <--SubDetail ZQuery2.ApplayUpdates; <-- Detail end; But, it...

Hallo, I have this scenario: - ZConnection1, set AutoCommit=True; - ZQuery1, Master, set to CachedUpdates = False; - ZQuery2, Detail, set to: CachedUpdates = True; DataSource = ZQuery1; - ZQuery3, SubDetail, set to: CachedUpdates = True; DataSource = ZQuery2. All ZQuery.Connection = ZConnection1; I ...

When you use One connection per App, connection overhead is smallest and all querys are handled one by one using one transaction. Mark Ok. I understand that if I start a transaction like Conn.StartTransaction the property AutoCommit becomes False and viceversa? I have - One connection per App with ...

Hallo, I try to understanding usage of TZConnection. Is usefull use One TZConnection per DataModule or One TZConnection per Application what is the difference from the two way? I try to develop an application with more (like 50) DataModule. Any of this DataModule have a lot of TZQuery. Thanks, Luigi

Hallo,
I try to use ZeosLib on D5.

I ask you to understand usage of DesignConnection property.

Tanks.

... Please attach a minimal project showing the error and the script needed to set up the database. Hi Mark, while I prepared the example I have uncovered where I mistook. :oops: During create table in database I assigned wrong default, see wrong code: CREATE TABLE CEDOLINI ( ID_CEDOLINO Integer NO...

Hallo, I have this error message: SQL Error: conversione error from string "0". Error Code: -413. Overflow occurred during datatype conversion. I use delphi 5 with zeos 6.6.4. I need to use a TTimeField that can have 0.00 time inside but when I try to save the query, I have the error above...