Hello, Alexander Kolokolzov!
You wrote on Wed, 15 Feb 2006 18:09:29 +0700:
AK> ××ÏÄ × ÐÏÌÅ ÔÉÐÁ CHAR (ÉÌÉ VARCHAR, ÎÅ×ÁÖÎÏ) ÔÏÌØËÏ ÃÉÆÒ É ÓÄÅÌÁÔØ
AK> ÜÔÏ ÎÁ ÓÅÒ×ÅÒÅ ÓÒÅÄÓÔ×ÁÍÉ sql.
create table test(
id char(100)
check (id is null or cast(id as integer) <> cast(id as integer)+1)
);
insert into test values('155'); -- ËÁÎÁÅÔ
insert into test values('155asdas'); -- ÁÛÉÐËÁ ÔÒÁÎÓÌÉÔÅÒÁÃÉÉ
insert into test values(null); -- ËÁÎÁÅÔ
Á ×ÏÔ
drop table test
ÎÅ ËÁÎÁÅÔ :-( ÇÒÉÔ ÍÏÌ:
unsuccessful metadata update
ERASE RDB$RELATION_FIELDS failed
action cancelled by trigger (1) to preserve data integrity
Cannot delete trigger used by a CHECK Constraint
ÓËÁÖÉÔÅ, ÞÏ ÕÄÁÌÉÔØ ÎÁÄÁ ÅÝ£?
AK> éÌÉ ÐÏÊÔÉ É ÊÁÄÕ ×ÙÐÉÔØ?
ÐÏÍÏÖÅÔ? :-)
æ£ÄÏÒÏ× å×ÇÅÎÉÊ.
úáï "ôÒÅÓÔ-í". åËÁÔÅÒÉÎÂÕÒÇ.
