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]