Hi,
I imported a Firebird database into Schema Modeler, and that I update the column mappings, I get this error.
Also, when getting a column design-time data from Delphi XE5, I get the error “An exception was raised on the server: Impossible d’effectuer un cast d’un object de type ‘System.TimeSpan’ en type ‘System.IConvertible’”
Do you have an idea of what this is about?
Hello
Could you provide DDL of the database table?
TIA
This is the DDL of the table in question.
CREATE TABLE TCTEST
(
CLIENT D_LKP_A_V10_NN ,
MANDAT D_LKP_A_V10_NN ,
DEBOURSE D_LKP_A_V10_NN ,
ACTIVITE D_LKP_A_V10_NN ,
RESP D_LKP_A_V10_NN ,
DATETEC D_T_DATE_NN ,
T D_A_V1_NN_ALPHA_ADF ,
SEQ D_N_ENTIER_NN_VP_ID ,
ANNEE D_N_ECOURT_NN_ANNEE ,
MOIS D_N_ECOURT_NN_D_MOIS ,
REFERENCE D_N_ECOURT_NN_D_SEMAINE ,
TAG D_T_DATE_TAG ,
CATTAUX D_N_ECOURT_NN_D_CAT_TAUX_ACT ,
INI D_A_V2_NN_D_INI ,
DEBUT D_T_TIME_NA_D_DBT ,
FIN D_T_TIME ,
DUREE D_T_TIME ,
HC D_B_NN_D_F ,
UNITES D_N_N185_D_UNITAIRE ,
COUT D_N_N182_MONETAIRE ,
COUTTOTAL D_N_N182_MONETAIRE ,
TAUX D_N_N182_MONETAIRE ,
NOFACTURE D_A_V10_MA_NO_FACTURE ,
TEMPS D_N_N182_MONETAIRE ,
DEBOURS D_N_N182_MONETAIRE ,
FACTURE D_N_N182_MONETAIRE ,
RADIATION D_N_N182_MONETAIRE ,
SOLDE D_N_N182_NN_D_MONETAIRE ,
CUMULATIF D_N_N182_MONETAIRE ,
COMMENTAIRES D_A_V120_COMMENTAIRES_TEC ,
NOCOMPTECLIENT D_A_V10_MA ,
X D_A_V1_X ,
IDTAG D_N_ENTIER ,
TS D_B_NN_D_F ,
AJOUTLE D_T_DATETIME_NN_D_AJOUT_LE ,
MODIFLE D_T_DATETIME_NA ,
CONSTRAINT PK_TCTEST PRIMARY KEY (SEQ)
);And those are the domains I defined in the database.
CREATE DOMAIN D_A_C10_PRIV AS
CHAR(10)
COLLATE UNICODE;
CREATE DOMAIN D_A_V10_MA AS
VARCHAR(10)
CHECK ((VALUE = UPPER(VALUE) OR VALUE IS NULL))
COLLATE UNICODE;
CREATE DOMAIN D_A_V10_MA_NO_FACTURE AS
VARCHAR(10)
CHECK ((VALUE = UPPER(VALUE) OR VALUE IS NULL))
COLLATE UNICODE;
CREATE DOMAIN D_A_V10_NN_MA AS
VARCHAR(10)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V10_NN_MA_MDP AS
VARCHAR(10)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V10_NN_MA_NO_FACTURE AS
VARCHAR(10)
NOT NULL
CHECK ((VALUE = UPPER(VALUE) OR VALUE IS NULL))
COLLATE UNICODE;
CREATE DOMAIN D_A_V11_NAS AS
VARCHAR(11)
COLLATE UNICODE;
CREATE DOMAIN D_A_V11_UPDATE_DELETE_RULE AS
VARCHAR(11)
COLLATE UNICODE;
CREATE DOMAIN D_A_V120_COMMENTAIRES_TEC AS
VARCHAR(120)
COLLATE UNICODE;
CREATE DOMAIN D_A_V120_MSG AS
VARCHAR(120)
COLLATE UNICODE;
CREATE DOMAIN D_A_V128_LISTE_CHAMPS_BD AS
VARCHAR(128)
COLLATE UNICODE;
CREATE DOMAIN D_A_V128_NN_CODE_ENT AS
VARCHAR(128)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V128_NOM_INDEX AS
VARCHAR(128)
COLLATE UNICODE;
CREATE DOMAIN D_A_V128_REPERTOIRE AS
VARCHAR(128)
COLLATE UNICODE;
CREATE DOMAIN D_A_V128_RESULT_MSG AS
VARCHAR(128)
COLLATE UNICODE;
CREATE DOMAIN D_A_V12_TEL AS
VARCHAR(12)
COLLATE UNICODE;
CREATE DOMAIN D_A_V15_NN_MA_SELECTION_CLIENT AS
VARCHAR(15)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_ALPHA_ADF AS
VARCHAR(1)
NOT NULL
CHECK (VALUE IN ('A','D','F','R'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_CAT_CLIENT AS
VARCHAR(1)
DEFAULT 'Z'
NOT NULL
CHECK (VALUE IN ('A','B','C','D','Z'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_ALPHA_A AS
VARCHAR(1)
DEFAULT 'A'
NOT NULL
CHECK (VALUE = 'A')
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_ALPHA_BR AS
VARCHAR(1)
DEFAULT 'B'
NOT NULL
CHECK (VALUE IN ('B','R', 'V'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_ALPHA_CT AS
VARCHAR(1)
DEFAULT 'C'
NOT NULL
CHECK (VALUE IN('C','T'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_ALPHA_D AS
VARCHAR(1)
DEFAULT 'D'
NOT NULL
CHECK (VALUE = 'D')
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_ALPHA_F AS
VARCHAR(1)
DEFAULT 'F'
NOT NULL
CHECK (VALUE = 'F')
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_CODE_ACTIVITE AS
VARCHAR(1)
DEFAULT 'A'
NOT NULL
CHECK (VALUE IN('A','D'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_CODE_DATE_CONFIRM AS
VARCHAR(1)
DEFAULT 'A'
NOT NULL
CHECK (VALUE IN('A','F','J'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_DML_IMS AS
VARCHAR(1)
DEFAULT 'M'
NOT NULL
CHECK (VALUE IN ('I', 'M', 'S'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_EIS AS
VARCHAR(1)
DEFAULT 'E'
NOT NULL
CHECK (VALUE IN ('E','I','S'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_RESP_AGR AS
VARCHAR(1)
DEFAULT 'R'
NOT NULL
CHECK (VALUE IN ('A','G','R'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_D_TYPE_CALCUL_DEBOURS AS
VARCHAR(1)
DEFAULT 'D'
NOT NULL
CHECK (VALUE IN ('D', 'P'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_GL_EF AS
VARCHAR(1)
NOT NULL
CHECK (VALUE IN ('A','P','C','R','D'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_SELECTION_CONF_LOT AS
VARCHAR(1)
NOT NULL
CHECK (VALUE IN('C','P','R', 'T'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_NN_SI_ECRITURES_PRJTS AS
VARCHAR(1)
NOT NULL
CHECK (VALUE IN('C','D','F','P','T'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_TYPE_FACTURE_TEC AS
VARCHAR(1)
CHECK ((VALUE IS NULL) OR VALUE IN ('F','R','P',NULL))
COLLATE UNICODE;
CREATE DOMAIN D_A_V1_X AS
VARCHAR(1)
CHECK (VALUE = 'X' OR VALUE IS NULL OR VALUE = '')
COLLATE UNICODE;
CREATE DOMAIN D_A_V20 AS
VARCHAR(20)
COLLATE UNICODE;
CREATE DOMAIN D_A_V200_NN_MA_OPTIONS AS
VARCHAR(200)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V20_NN_DESCRIPTION AS
VARCHAR(20)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V20_NN_RESUME AS
VARCHAR(20)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V256_LISTE_CHAMPS_BD AS
VARCHAR(256)
COLLATE UNICODE;
CREATE DOMAIN D_A_V256_RESULT_MSG_BD AS
VARCHAR(256)
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_CODE_BGT AS
VARCHAR(2)
DEFAULT 'I'
NOT NULL
CHECK (VALUE IN ('C','F','I','NI','M','V'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_INI AS
VARCHAR(2)
DEFAULT 'I'
NOT NULL
CHECK (VALUE IN ('I','NI'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_LANGUE AS
VARCHAR(2)
DEFAULT 'FR'
NOT NULL
CHECK (VALUE IN ('FR', 'AN'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_MAPA AS
VARCHAR(2)
DEFAULT 'PA'
NOT NULL
CHECK (VALUE IN ('MA','PA'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_MODULE AS
VARCHAR(2)
DEFAULT 'TC'
NOT NULL
CHECK (VALUE IN ('CC','TC','AR'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_PAPIER_FORMAT AS
VARCHAR(2)
DEFAULT 'LE'
NOT NULL
CHECK (VALUE IN ('LE', 'LG'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_PAPIER_ORIENTATION AS
VARCHAR(2)
DEFAULT 'PO'
NOT NULL
CHECK (VALUE IN ('PO', 'PA'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_D_TYPE_CALCUL_TEC AS
VARCHAR(2)
DEFAULT 'FA'
NOT NULL
CHECK (VALUE IN ('FA', 'RA', 'PR', 'MA'))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_MA AS
VARCHAR(2)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V2_NN_PERIODE AS
VARCHAR(2)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V30_LETTRES AS
VARCHAR(30)
COLLATE UNICODE;
CREATE DOMAIN D_A_V31_NN_NOM_TABLE AS
VARCHAR(31)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V31_NOM_OBJET_BD AS
VARCHAR(31)
COLLATE UNICODE;
CREATE DOMAIN D_A_V4_MA AS
VARCHAR(4)
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V4_NN_MA AS
VARCHAR(4)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V512_TEXTE_STATEMENT AS
VARCHAR(512)
COLLATE UNICODE;
CREATE DOMAIN D_A_V52_VILLE_PROVINCE AS
VARCHAR(52)
COLLATE UNICODE;
CREATE DOMAIN D_A_V5_MA AS
VARCHAR(5)
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_A_V60 AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_ADRESSE AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_COMMENTAIRES AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_CONTACT AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_DESCRIPTION AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_NN_DESCRIPTION AS
VARCHAR(60)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_NN_NOM AS
VARCHAR(60)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_NOM AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_NO_COMPTE_BANQUE AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V60_WEB_COURRIEL AS
VARCHAR(60)
COLLATE UNICODE;
CREATE DOMAIN D_A_V64 AS
VARCHAR(64)
COLLATE UNICODE;
CREATE DOMAIN D_A_V64_NN_FICHE_MENU AS
VARCHAR(64)
NOT NULL
COLLATE UNICODE;
CREATE DOMAIN D_A_V64_SERVEUR_BD_FICHIER AS
VARCHAR(64)
COLLATE UNICODE;
CREATE DOMAIN D_A_V6_CMD AS
VARCHAR(6)
COLLATE UNICODE;
CREATE DOMAIN D_A_V7_CODE_POSTAL AS
VARCHAR(7)
COLLATE UNICODE;
CREATE DOMAIN D_B_NN_D_F AS
VARCHAR(1)
DEFAULT 'F'
NOT NULL
CHECK (VALUE IN ('T','F'))
COLLATE UNICODE;
CREATE DOMAIN D_B_NN_D_NON AS
VARCHAR(3)
DEFAULT 'NON'
NOT NULL
CHECK (VALUE = 'OUI' OR VALUE = 'NON')
COLLATE UNICODE;
CREATE DOMAIN D_B_NN_D_OUI AS
VARCHAR(3)
DEFAULT 'OUI'
NOT NULL
CHECK (VALUE = 'OUI' OR VALUE = 'NON')
COLLATE UNICODE;
CREATE DOMAIN D_B_NN_D_T AS
VARCHAR(1)
DEFAULT 'T'
NOT NULL
CHECK (VALUE IN ('T','F'))
COLLATE UNICODE;
CREATE DOMAIN D_B_OUI_NON AS
VARCHAR(3)
CHECK ((VALUE IS NULL) OR (VALUE IN ('OUI','NON', NULL)))
COLLATE UNICODE;
CREATE DOMAIN D_B_T_F AS
VARCHAR(1)
CHECK ((VALUE IS NULL) OR (VALUE IN ('T','F', NULL)))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V10_NA AS
VARCHAR(10)
CHECK ((VALUE = UPPER(VALUE) OR (VALUE IS NULL)))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V10_NN AS
VARCHAR(10)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V1_NN AS
VARCHAR(1)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V2_NN AS
VARCHAR(2)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V4_NA AS
VARCHAR(4)
CHECK ((VALUE = UPPER(VALUE) OR (VALUE IS NULL)))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_A_V4_NN AS
VARCHAR(4)
NOT NULL
CHECK (VALUE = UPPER(VALUE))
COLLATE UNICODE;
CREATE DOMAIN D_LKP_N_ECOURT_NN_D_ACCES_DOC AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE IN (1, 2, 4, 8, 16))
;
CREATE DOMAIN D_LKP_N_ECOURT_NN_D_CODE_TAXES AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_LKP_N_ECOURT_NN_D_REFUS_DOC AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE IN (0, 1, 2, 4, 8, 16))
;
CREATE DOMAIN D_LKP_N_ENTIER_NA_AJOUT_ID AS
INTEGER
CHECK ((VALUE IS NULL) OR (VALUE >= 0))
;
CREATE DOMAIN D_LKP_N_ENTIER_NA_MODIF_ID AS
INTEGER
CHECK ((VALUE IS NULL) OR (VALUE >= 0))
;
CREATE DOMAIN D_LKP_N_ENTIER_NN AS
INTEGER
NOT NULL
CHECK ((VALUE >= 0))
;
CREATE DOMAIN D_LKP_N_ENTIER_NN_CIE AS
INTEGER
NOT NULL
CHECK ((VALUE >= 0))
;
CREATE DOMAIN D_LKP_N_ENTIER_NN_D AS
INTEGER
DEFAULT 0
NOT NULL
CHECK ((VALUE >= 0))
;
CREATE DOMAIN D_LKP_N_ENTIER_NN_USAGER_ID AS
INTEGER
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_LKP_N_ENTIER_VP_NA AS
INTEGER
CHECK ((VALUE IS NULL) OR (VALUE >= 0))
;
CREATE DOMAIN D_M_BLOB_MEMO AS
BLOB SUB_TYPE 1 SEGMENT SIZE 80
;
CREATE DOMAIN D_N_ECOURT AS
SMALLINT
;
CREATE DOMAIN D_N_ECOURT_NN_ANNEE AS
SMALLINT
NOT NULL
CHECK (
VALUE BETWEEN 1975 AND 2020
)
;
CREATE DOMAIN D_N_ECOURT_NN_BGT_ANNEE AS
SMALLINT
NOT NULL
CHECK (
VALUE BETWEEN 1975 AND 2020
)
;
CREATE DOMAIN D_N_ECOURT_NN_D AS
SMALLINT
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_ECOURT_NN_D_ACCES_DOC AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE IN (1, 2, 4, 8, 16))
;
CREATE DOMAIN D_N_ECOURT_NN_D_CAT_TAUX_ACT AS
SMALLINT
DEFAULT '1'
NOT NULL
CHECK (VALUE BETWEEN 1 AND 5)
;
CREATE DOMAIN D_N_ECOURT_NN_D_CAT_TAUX_MSN AS
SMALLINT
DEFAULT '0'
NOT NULL
CHECK (VALUE BETWEEN 0 AND 5)
;
CREATE DOMAIN D_N_ECOURT_NN_D_CODE_CONTACT AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE BETWEEN 0 AND 3)
;
CREATE DOMAIN D_N_ECOURT_NN_D_CODE_EPURER_RAP AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE BETWEEN 0 AND 9)
;
CREATE DOMAIN D_N_ECOURT_NN_D_CODE_REP_DOC AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE IN (1, 2))
;
CREATE DOMAIN D_N_ECOURT_NN_D_CODE_TAXES AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_NN_D_DROIT_DOC AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE IN (0, 1, 2, 4, 8, 16))
;
CREATE DOMAIN D_N_ECOURT_NN_D_DROIT_MENU AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE IN (1, 4, 8))
;
CREATE DOMAIN D_N_ECOURT_NN_D_JRSAVISBKP AS
SMALLINT
DEFAULT 7
NOT NULL
CHECK (VALUE BETWEEN 0 AND 31)
;
CREATE DOMAIN D_N_ECOURT_NN_D_MINHAUTEUR AS
SMALLINT
DEFAULT 300
NOT NULL
CHECK (VALUE >= 300)
;
CREATE DOMAIN D_N_ECOURT_NN_D_MINLARGEUR AS
SMALLINT
DEFAULT 500
NOT NULL
CHECK (VALUE >= 500)
;
CREATE DOMAIN D_N_ECOURT_NN_D_MOIS AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (value between 1 and 12)
;
CREATE DOMAIN D_N_ECOURT_NN_D_NBRE_JOURS AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_NN_D_NBRE_LICENCE AS
SMALLINT
DEFAULT '1'
NOT NULL
CHECK (VALUE > 0)
;
CREATE DOMAIN D_N_ECOURT_NN_D_NO_LICENCE AS
SMALLINT
DEFAULT 9000
NOT NULL
CHECK (VALUE BETWEEN 9000 AND 9999)
;
CREATE DOMAIN D_N_ECOURT_NN_D_PA_JRNL AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE BETWEEN 0 AND 99)
;
CREATE DOMAIN D_N_ECOURT_NN_D_REFUS_DOC AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE IN (0, 1, 2, 4, 8, 16))
;
CREATE DOMAIN D_N_ECOURT_NN_D_SEMAINE AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE BETWEEN 1 AND 53)
;
CREATE DOMAIN D_N_ECOURT_NN_D_TYPEPROF AS
SMALLINT
DEFAULT '0'
NOT NULL
CHECK (value between 0 and 2)
;
CREATE DOMAIN D_N_ECOURT_NN_VP AS
SMALLINT
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_NN_VP_D AS
SMALLINT
DEFAULT 0
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_NN_VP_D1 AS
SMALLINT
DEFAULT 1
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_VP_D_RPT_FACT AS
SMALLINT
DEFAULT 0
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ECOURT_VP_D_SELECTION_ID AS
SMALLINT
DEFAULT 1
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER AS
INTEGER
;
CREATE DOMAIN D_N_ENTIER_NA_USAGER_ID AS
INTEGER
CHECK ((VALUE IS NULL) OR (VALUE >= 0))
;
CREATE DOMAIN D_N_ENTIER_NA_VP_D_NBRE AS
INTEGER
DEFAULT 0
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER_NN_D AS
INTEGER
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_ENTIER_NN_VP AS
INTEGER
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER_NN_VP_D AS
INTEGER
DEFAULT 0
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER_NN_VP_D1 AS
INTEGER
DEFAULT 1
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER_NN_VP_ID AS
INTEGER
NOT NULL
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_ENTIER_RESULT_ERREUR AS
INTEGER
;
CREATE DOMAIN D_N_ENTIER_RESULT_NOMBRE AS
INTEGER
;
CREATE DOMAIN D_N_ENTIER_VP AS
INTEGER
CHECK (VALUE >= 0)
;
CREATE DOMAIN D_N_N182_MONETAIRE AS
NUMERIC(18,2)
;
CREATE DOMAIN D_N_N182_NN_D_MONETAIRE AS
NUMERIC(18,2)
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_N183_D_POURCENTAGE AS
NUMERIC(18,3)
DEFAULT 0.0
;
CREATE DOMAIN D_N_N183_HEURE_BGT AS
NUMERIC(18,3)
;
CREATE DOMAIN D_N_N183_NN_D_HEURE_BGT AS
NUMERIC(18,3)
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_N183_NN_D_TAUX_MENSUEL AS
NUMERIC(18,3)
DEFAULT 1.00
NOT NULL
CHECK (VALUE BETWEEN 0 AND 3)
;
CREATE DOMAIN D_N_N183_NN_D_UNITAIRE AS
NUMERIC(18,3)
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_N183_NN_TAUX_PARAMETRE AS
NUMERIC(18,3)
NOT NULL
CHECK ((VALUE BETWEEN 0 AND 100))
;
CREATE DOMAIN D_N_N183_NN_TAUX_TPSTVQ AS
NUMERIC(18,3)
NOT NULL
CHECK ((VALUE BETWEEN 0 AND 100))
;
CREATE DOMAIN D_N_N183_VP_D_POURCENTAGE AS
NUMERIC(18,3)
DEFAULT 0.0
CHECK (VALUE BETWEEN 0 AND 100)
;
CREATE DOMAIN D_N_N185_D_UNITAIRE AS
NUMERIC(18,5)
DEFAULT 0.0
;
CREATE DOMAIN D_N_N185_NN_D_UNITAIRE AS
NUMERIC(18,5)
DEFAULT 0
NOT NULL
;
CREATE DOMAIN D_N_N185_UNITAIRE AS
NUMERIC(18,5)
;
CREATE DOMAIN D_T_DATE AS
DATE
;
CREATE DOMAIN D_T_DATETIME_NA AS
TIMESTAMP
;
CREATE DOMAIN D_T_DATETIME_NN_D_AJOUT_LE AS
TIMESTAMP
DEFAULT 'NOW'
NOT NULL
;
CREATE DOMAIN D_T_DATE_D_TODAY AS
DATE
DEFAULT 'TODAY'
;
CREATE DOMAIN D_T_DATE_NAISSANCE AS
DATE
CHECK (VALUE BETWEEN '1900/01/01' AND 'TODAY')
;
CREATE DOMAIN D_T_DATE_NN AS
DATE
NOT NULL
;
CREATE DOMAIN D_T_DATE_NN_D_TODAY AS
DATE
DEFAULT 'TODAY'
NOT NULL
;
CREATE DOMAIN D_T_DATE_TAG AS
DATE
;
CREATE DOMAIN D_T_TIME AS
TIME
;
CREATE DOMAIN D_T_TIME_NA_D_DBT AS
TIME
DEFAULT 'NOW'
;Hello
Thank you for the DDL script. The issue has been reproduced.
The TIME datatype is not supported by Data Abstract, but there shouldn’t be any exceptions. Such columns should be ignored w/o throwing exceptions, especially in the Schema Modeler.
Regards