Subject | RE: [IBO] Domain Problem |
---|---|
Author | Jason Wharton |
Post date | 2017-09-29T16:21:20Z |
You will probably need to send it to me directly at support@....
Thanks,
Jason Wharton
www.ibobjects.com
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, September 29, 2017 10:18 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Domain Problem
Hi Jason
this is the example you asked for me.
If you click the "Append False" button, the problem occurs. The PRINT field
has the value of the property required to False because in my application
the fields that have the problem have this property so valued.
Thank you
Il 29/09/2017 17:08, 'Jason Wharton' supportlist@... [IBObjects]
ha scritto:
*Gianluca Silvagni *
Sviluppo Software | Lasersoft S.r.l. <http://www.lasersoft.it> T. +39
0541393206 | Fax. +39 0541393063 gianluca.silvagni@...
<mailto:gianluca.silvagni@...>
Via Coriano, 58 | Center Gros Blocco 56/F| Rimini (RN)| 47924
*Segui Lasersoft sui social media
*
facebooklinkedin
<https://www.linkedin.com/company/lasersoft?trk=prof-following-company-logo>
youtube
<https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
Facebook <https://www.facebook.com/Lasersoft-506588426215843/?fref=ts>
|LinkedIn
<https://www.linkedin.com/company/lasersoft?trk=prof-following-company-logo>
|
YouTube <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
/Ai sensi del Codice in materia di protezione dei dati personali (
d.L.vo 196/03), il contenuto di questa e-mail e degli eventuali allegati
sono riservati e ad uso esclusivo del destinatario. Chiunque riceva
questo messaggio per errore è pregato di distruggerlo e contattare il
mittente. Si informa inoltre che la risposta alla presente compresi
eventuali allegati potrebbero essere visionati, ai fini del disbrigo
delle competenze lavorative, anche da altro personale addetto./
[Non-text portions of this message have been removed]
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links
Thanks,
Jason Wharton
www.ibobjects.com
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, September 29, 2017 10:18 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Domain Problem
Hi Jason
this is the example you asked for me.
If you click the "Append False" button, the problem occurs. The PRINT field
has the value of the property required to False because in my application
the fields that have the problem have this property so valued.
Thank you
Il 29/09/2017 17:08, 'Jason Wharton' supportlist@... [IBObjects]
ha scritto:
>--
> I need for you to provide me with a sample app so I can see all of the
> varying factors involved. For example, I don't know what component you
> are using. It does matter.
> There are many possible factors that can be affecting things and so I
> need a sample app to answer all the questions I don't even know to
> ask.
>
> Thanks,
> Jason Wharton
> www.ibobjects.com
>
> _____
>
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
> Sent: Thursday, September 28, 2017 2:07 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Domain Problem
>
> Hi Jason
>
> sorry, the correct domain is the following, so also the default value
> is 1 character. I do not know why, but many years ago this domain was
> created to encode all the boolean fields in my application. When the
> field has to be encoded with the False value, the value is ' ', so the
> length is 1. I hope you can fix this problem.
>
> Thank you
>
> CREATE DOMAIN BOOL
> AS char (1)
> DEFAULT ' '
> NOT NULL
> CHECK (VALUE IN ('S', ' '))
> COLLATE ISO8859_1;
>
> Il 27/09/2017 19:52, 'Jason Wharton' supportlist@...
> [IBObjects] ha scritto:
>
> I'll look into this more as to why things are different in IBO now
> compared to before.
>
> Also, the CHAR column type isn't designed to have zero length. You
> should use VARCHAR if you want an empty string.
>
> Jason Wharton
> www.ibobjects.com
>
> _____
>
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
> Sent: Wednesday, September 27, 2017 9:08 AM
> To: IBObjects@yahoogroups.com
> Cc: Jason Wharton; Jason Wharton
> Subject: [IBO] Domain Problem
>
> Hello
>
> I have this domain:
>
> CREATE DOMAIN BOOL
> AS char (1)
> DEFAULT ''
> NOT NULL
> CHECK (VALUE IN ('S', ''))
> COLLATE ISO8859_1;
>
> When I used XE4 with the old version of IBO, if I had a Domain Bool
> field, if I did not validate it, it was automatically upgraded to the
> default value.
>
> Now, with the new IBO (TIBOTable) components, it is not valued with
> the default value and the post generates the error because the field
> can not be null.
>
> How can I fix the problem?
>
> Thank you.
>
> --
> Gianluca Silvagni
> Sviluppo Software | Lasersoft S.r.l. <http://www.lasersoft.it>
> <http://www.lasersoft.it> T. +39 0541393206 | Fax. +39 0541393063
> gianluca.silvagni@...
>
> Via Coriano, 58 | Center Gros Blocco 56/F| Rimini (RN)| 47924
>
> Segui Lasersoft sui social media
>
>
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo>
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo> linkedin
> <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
> <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg> youtube
>
> <https://www.facebook.com/Lasersoft-506588426215843/?fref=ts>
> <https://www.facebook.com/Lasersoft-506588426215843/?fref=ts> Facebook
> |
>
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo>
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo>
> LinkedIn| <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
> <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
> YouTube
>
> Ai sensi del Codice in materia di protezione dei dati personali (
> d.L.vo 196/03), il contenuto di questa e-mail e degli eventuali
> allegati sono riservati e ad uso esclusivo del destinatario. Chiunque
> riceva questo messaggio per errore è pregato di distruggerlo e
> contattare il mittente. Si informa inoltre che la risposta alla
> presente compresi eventuali allegati potrebbero essere visionati, ai
> fini del disbrigo delle competenze lavorative, anche da altro
> personale addetto.
>
> [Non-text portions of this message have been removed]
>
> --
> Gianluca Silvagni
> Sviluppo Software | Lasersoft S.r.l. <http://www.lasersoft.it> T. +39
> 0541393206 | Fax. +39 0541393063 gianluca.silvagni@...
>
> Via Coriano, 58 | Center Gros Blocco 56/F| Rimini (RN)| 47924
>
> Segui Lasersoft sui social media
>
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo> linkedin
> <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
> youtube
>
> <https://www.facebook.com/Lasersoft-506588426215843/?fref=ts> Facebook
> |
> <https://www.linkedin.com/company/lasersoft?trk=prof-following-company
> -logo>
> LinkedIn| <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
> YouTube
>
> Ai sensi del Codice in materia di protezione dei dati personali (
> d.L.vo 196/03), il contenuto di questa e-mail e degli eventuali
> allegati sono riservati e ad uso esclusivo del destinatario. Chiunque
> riceva questo messaggio per errore è pregato di distruggerlo e
> contattare il mittente. Si informa inoltre che la risposta alla
> presente compresi eventuali allegati potrebbero essere visionati, ai
> fini del disbrigo delle competenze lavorative, anche da altro
> personale addetto.
>
> [Non-text portions of this message have been removed]
>
>
*Gianluca Silvagni *
Sviluppo Software | Lasersoft S.r.l. <http://www.lasersoft.it> T. +39
0541393206 | Fax. +39 0541393063 gianluca.silvagni@...
<mailto:gianluca.silvagni@...>
Via Coriano, 58 | Center Gros Blocco 56/F| Rimini (RN)| 47924
*Segui Lasersoft sui social media
*
facebooklinkedin
<https://www.linkedin.com/company/lasersoft?trk=prof-following-company-logo>
youtube
<https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
Facebook <https://www.facebook.com/Lasersoft-506588426215843/?fref=ts>
<https://www.linkedin.com/company/lasersoft?trk=prof-following-company-logo>
|
YouTube <https://www.youtube.com/channel/UChLks2BERqKeJbsp6c8QgQg>
/Ai sensi del Codice in materia di protezione dei dati personali (
d.L.vo 196/03), il contenuto di questa e-mail e degli eventuali allegati
sono riservati e ad uso esclusivo del destinatario. Chiunque riceva
questo messaggio per errore è pregato di distruggerlo e contattare il
mittente. Si informa inoltre che la risposta alla presente compresi
eventuali allegati potrebbero essere visionati, ai fini del disbrigo
delle competenze lavorative, anche da altro personale addetto./
[Non-text portions of this message have been removed]
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links