> create table test(id integer, val varchar2(10));
> insert into test values(1, '');
> insert into test values(2, 'f');
> insert into test values(3, null);
> select * from test where val is null;
îÅ ÎÕ ÜÔÏ ÐÒÏÓÔÏ... îÁ ÔÁËÏÍ ÕÖ ÓÐÅÃÙ ïÒÁËÌÁ ×ÒÏÄÅ ÎÅ ÓÐÏÔÙËÁÀÔÓÑ :)
îÁÓËÏÌØËÏ Ñ ÐÏÍÎÀ üôá ÂÁÇÁ ×ÓÐÌÙ×ÁÅÔ ÔÁË:
insert into table values (:field1)
Á ÔÅÐÅÒØ ÎÁÐÒÉÍÅÒ × Delphi,
ParamByName('field1').AsString := '';
ÐÒÉÞÅÍ ×ÏÓÐÏÌØÚÏ×ÁÔØÓÑ ÕÎÉ×ÅÒÓÁÌØÎÙÍÉ ËÏÍÐÏÎÅÎÔÁÍÉ ÄÏÓÔÕÐÁ, ËÏÔÏÒÙÅ ÔÕÐÏ ÎÅ
ÐÒÉÒÁ×ÎÑÀÔ ''=NULL × ÍÏÍÅÎÔ ÏÔÐÒÁ×ËÉ ÎÁ ÓÅÒ×ÅÒ (ÎÅ ÉÈ ÜÔÏ ÓÏÂÓÔ×ÅÎÎÏ É
ÚÁÄÁÞÁ, ÐÏÄÍÅÔÁÔØ ÚÁ ÂÁÇÁÍÉ Oracle).
_____________________________
ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ íÏÇÉÌØÎÙÊ.
