Search found 107 matches
- 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...
- 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...
- 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
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
- 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...
- 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 :...
- 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 ...
- 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...
- 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 ...
- 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
This works.marsupilami wrote: ↑30.04.2021, 08:33 With TortoiseSVN please use 'svn://svn.code.sf.net/p/zeoslib/code-0/trunk'.
Thanks
- 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 ...
- 30.04.2021, 10:18
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Column Date and Validating issue
- Replies: 8
- Views: 373
- 29.04.2021, 19:06
- 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
TortoiseSVN tells URL 'svn://svn.code.sf.net/p/zeoslib/code-0/trunk%20zeoslib-code-0' doesn't exists
Hello,
like subject. I get the URL from https://sourceforge.net/p/zeoslib/code- ... ree/trunk/
Only I have this result if try checkout with TortoiseSVN?
Thanks.
like subject. I get the URL from https://sourceforge.net/p/zeoslib/code- ... ree/trunk/
Only I have this result if try checkout with TortoiseSVN?
Thanks.
- 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
I installed new release 7517 but not work, OnValidate is unusable
Thanks
- 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...
- 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...