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
Bookmarks