Hello,
i create a Table in Access via SQL
CREATE TABLE CRITERES (
[CRT_CODE] VARCHAR(15) NOT NULL,
[CRT_FIELDNAME] VARCHAR(30) NOT NULL,
[CRT_NUMERO] INTEGER NULL,
[CRT_LIBELLE] VARCHAR(50) NULL)
In Access, i see that the field CRT_LIBELLE must be filled and cannot be
empty.
I got a error when i do : (because CRT_LIBELLE is empty)
INSERT INTO CRITERES VALUES ('TOTO', 'TITI', 0, '')
In Access, when i go to the table's definition , and when i am on the
field
CRT_LIBELLE, i see :
Chaine vide authorisée : Non
How can i do to put YES (to allow empty string) via SQL ?
Comment faire pour y mettre oui en passant par SQL ?
|
