Subject Re: [IBO] Domain Problem
Author Gianluca Silvagni - Lasersoft s.r.l.
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
>
> 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
>
> <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
>
> facebook
> <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>
|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]