Hi,

I have created a table in Lianja as

? SQLEXEC(lnconn,"Create table mytest (invno n(10) not null, dated t not null set default {})")

? SQLEXEC(lnconn,"select * from mytest")

? SQLEXEC(lnconn,"insert into mytest (invno) values (1)")
? SQLEXEC(lnconn,"insert into mytest (invno) values (2)")

? SQLEXEC(lnconn,"select * from mytest")

? ISNULL(dated) && print as .F.

and also

? empty(dated) && print as .F.

when I browse the resultset, it shows empty datetime value in dated column. How can I get empty .T. value for "dated" column ?

Regards
Naeem