Search found 107 matches

by louis
12.05.2021, 07:48
Forum: ZeosLib 7.3/8.0 Forum
Topic: TZFields against TFields and DisableZFields Property
Replies: 2
Views: 141

TZFields against TFields and DisableZFields Property

Hello, What is the purpose and the right use of the TZFields, why I must prefer TZFields against the ordinary TFields of Delphi? Why they are not registered on Delphi and from FieldsEditor cannot create permanet TZFields for ZTable or ZQuery? What is the purpose and the right use of the property Dis...
by louis
09.05.2021, 10:10
Forum: ZeosLib 7.3/8.0 Forum
Topic: Mapping Firebird Fields and not registration TZFields
Replies: 4
Views: 260

Re: Mapping Firebird Fields and not registration TZFields

Can you give more details or an example again? I need a lookup fields and Firebird Smallint don't lookup on Smallint but Shortint does. I create TSmallintField for lookup to TSmallintField in other table but it can't lookup, it fails. If i create TShortIntField for lookup to TSmallintField in other...
by louis
07.05.2021, 08:33
Forum: ZeosLib 7.3/8.0 Forum
Topic: Mapping Firebird Fields and not registration TZFields
Replies: 4
Views: 260

Re: Mapping Firebird Fields and not registration TZFields

Hello,
i create a Ticket #512 https://sourceforge.net/p/zeoslib/tickets/512/

How i can close the ticket when resolved, if I can close it?

Thanks
by louis
04.05.2021, 15:04
Forum: ZeosLib 7.3/8.0 Forum
Topic: Mapping Firebird Fields and not registration TZFields
Replies: 4
Views: 260

Mapping Firebird Fields and not registration TZFields

Hello, in v8 how are mapped firebird fields? I have a lot of Loockupfields mapped "SmallintField" in V720b that I needs to convert in "ShortIntField" in V8. There are a list of mapping Firebird fields? Why the new TZFields not are registered? They not appears on FieldsEditor. Tha...
by louis
03.05.2021, 08:19
Forum: ZeosLib 7.3/8.0 Forum
Topic: Column Date and Validating issue
Replies: 8
Views: 373

Re: Column Date and Validating issue

Hello, may be i find the bug? in a procedure: procedure TZAbstractRODataset.SetFieldData(Field: TField; Buffer: {$IFDEF WITH_TVALUEBUFFER}TValueBuffer{$ELSE}Pointer{$ENDIF}; NativeFormat: Boolean); begin if Field.DataType in [ftWideString, ftBCD, ftDate, ftTime, ftDateTime] then begin NativeFormat :...
by louis
02.05.2021, 15:59
Forum: ZeosLib 7.3/8.0 Forum
Topic: Best/Right approch for master/Detail
Replies: 19
Views: 731

Re: Best/Right approch for master/Detail

One more word though: I don't know your requirements. I also construct the invoice in the same way and assign the number from the server in a trigger BeforeInsert of master table. My approch all or nothing is because the invoice update the quantity of items in depts, update customers credit and so ...
by louis
01.05.2021, 16:32
Forum: ZeosLib 7.3/8.0 Forum
Topic: Best/Right approch for master/Detail
Replies: 19
Views: 731

Re: Best/Right approch for master/Detail

Sure :) Thank you and sorry for the flame that was generated in the other posts. You can - just use the methods StartTransaction, Commit and Rollback of TZConnection. Maybe this wiki enty about TZConnection.Autocommit can help in understanding autocommit and transactions. Firebird is ever in transa...
by louis
30.04.2021, 16:04
Forum: ZeosLib 7.3/8.0 Forum
Topic: Best/Right approch for master/Detail
Replies: 19
Views: 731

Re: Best/Right approch for master/Detail

You do a ZConnection.StartTransaction before you start your changes. When you are finished with your changes, you either do a ZConnection.Commit to make them permanent in the database or you do a ZConnection.Rollback. Please, be patient. With property Autocommit = true of ZConnection I cannot gain ...
by louis
30.04.2021, 11:43
Forum: ZeosLib 7.3/8.0 Forum
Topic: TortoiseSVN tells URL 'svn://svn.code.sf.net/p/zeoslib/code-0/trunk%20zeoslib-code-0' doesn't exists
Replies: 2
Views: 274

Re: TortoiseSVN tells URL 'svn://svn.code.sf.net/p/zeoslib/code-0/trunk%20zeoslib-code-0' doesn't exists

marsupilami wrote: 30.04.2021, 08:33 With TortoiseSVN please use 'svn://svn.code.sf.net/p/zeoslib/code-0/trunk'.
This works.

Thanks
by louis
30.04.2021, 10:38
Forum: ZeosLib 7.3/8.0 Forum
Topic: Best/Right approch for master/Detail
Replies: 19
Views: 731

Re: Best/Right approch for master/Detail

Honestly - this is quite basic SQL. True, I come from paradox and until now I didn't give much importance to transactions. :oops: I realize that I need to go deeper but the texts I find is in English and I have a poor english. If I can ask You: a) Please, can you suggest a good text to learn about ...
by louis
29.04.2021, 19:03
Forum: ZeosLib 7.3/8.0 Forum
Topic: Column Date and Validating issue
Replies: 8
Views: 373

Re: Column Date and Validating issue

Hello,
I installed new release 7517 but not work, OnValidate is unusable :(

Thanks
by louis
28.04.2021, 19:00
Forum: ZeosLib 7.3/8.0 Forum
Topic: Column Date and Validating issue
Replies: 8
Views: 373

Re: Column Date and Validating issue

I try disabling ZFields (DisableZFields in ZQuery) and generate all new normal persistent fields. I wonder because now the value entered in a DBControl that contain ZQuery1DATA_REGISTRAZIONE is BLANK after OnValidate event even if the value was assignet at Column ZQuery1DATA_DOCUMENTO! there is a bu...
by louis
28.04.2021, 18:50
Forum: ZeosLib 7.3/8.0 Forum
Topic: Column Date and Validating issue
Replies: 8
Views: 373

Re: Column Date and Validating issue

Hello, now I notice that in an OnValidate event, the parameter Sender contains the new value but the Field still has the old value. Changing the code from: procedure TForm11.ztbDocTestaDATA_DOCUMENTOValidate(Sender: TField); begin if (ZQuery1DATA_DOCUMENTO.AsDateTime > ZQuery1DATA_REGISTRAZIONE.AsDa...