> óÉÔÕÁÃÉÑ ×ÙÇÌÑÄÉÔ ÔÁË
> - ÂÁÚÁ ÏÔ IB6
> - ÓÅÒ×ÅÒ FB 1.0.3
óÍÅÌÙÊ ÜËÐÅÒÉÍÅÎÔ ÓÏ×ÅÔÓËÉÈ ÕÞÅÎÙÈ Ó FB2.1 ÐÏËÁÚÁÌ ÓÌÅÄÕÀÝÉÅ ÒÅÚÕÌØÔÁÔÙ
-----------
CREATE TABLE TABLE_FOR_VIEW_NN
(
TEST_ID T_INTEGER NOT NULL,
COL_WITH_OWN_NN T_INTEGER NOT NULL,
COL_WITH_DOMAIN_NN T_INTEGER_NN,
COL_WITH_TWO_NN T_INTEGER_NN NOT NULL,
CONSTRAINT PK_TABLE_FOR_VIEW_NN
PRIMARY KEY (TEST_ID)
);//TABLE_FOR_VIEW_NN
CREATE VIEW V_TABLE_FOR_VIEW_NN
AS
SELECT TEST_ID,
COL_WITH_OWN_NN,
COL_WITH_DOMAIN_NN,
COL_WITH_TWO_NN
FROM TABLE_FOR_VIEW_NN;
--------
äÌÑ ×ÓÅÈ ÞÅÔÙÒÅÈ ËÏÌÏÎÏË ×ØÀÈÁ ÇÏ×ÏÒÉÔ - íÏÇ£Ô ÂÙÔØ NULL
To Vlad: ëÕÄÁ Ñ ×ÞÅÒÁ ÓÍÏÔÒÅÌ - ÎÅ ÚÎÁÀ. ÷ÒÏÄÅ ÎÅ ÓÕÂÂÏÔÁ ×ÅÄØ ÂÙÌÁ
-----
îÁ ×ÓÑËÉÊ ÓÌÕÞÁÊ, ÚÁÔÅÓÔÉÌ IB2007
äÌÑ COL_WITH_DOMAIN_NN, COL_WITH_TWO_NN - ×ØÀÈÁ ÇÏ×ÏÒÉÔ NOT NULL, Á ÄÌÑ
ÐÅÒ×ÙÈ Ä×ÕÈ (ÄÏÍÅÎ ÂÅÚ NOT NULL) - ÇÏ×ÏÒÉÔ, ÞÔÏ NULL ÐÉÓÁÔØ ÍÏÖÎÏ.
èÏÔØ ÜÔÏ ÍÎÅ ×ÞÅÒÁ ÎÅ ÐÏÍÅÒÅÝÉÌÏÓØ
----
ëÏ×ÁÌÅÎËÏ äÍÉÔÒÉÊ.
PS. ë ìÉÐÅÃËÕ ÐÒÉÂÌÉÖÁÅÔÓÑ ÁÈÔÕÎÇ. óÅÊÞÁÓ ÐÏÞÔÉ -20ó 8-) ... á ÍÙ, ÂÌÉÎ,
ÔÒÁ×Õ ÓËÉÒÄÕÅÍ...
