Subject | RE: [IBO] Domain Problem |
---|---|
Author | Jason Wharton |
Post date | 2017-09-27T17:52:57Z |
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>
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]
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>
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]