-
Empty or Null datetime values return problem Via Lianja ODBC
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks