Empty or Null datetime values return problem Via Lianja ODBC

[naeempk]

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

[barrymavin]

This is a replica of a ticket already submitted. Replies are being made on the ticket.

[naeempk]

Yes, you are correct. This is replica of my ticket.

1) Is there a way that we can share our tickets on Lianja forums? So that others also get informed.

I got this reply against my ticket

==============================
I'm not sure why it is returning .F. for empty(dated) in VFP - it returns .T. in Lianja and in ODBCTest.

This does return .T. in VFP - is this something you could use as an alternative?

? TTOC(dated) = ""
==============================

2) Is Lianja VFP language not compatible to MS VFP language ? It means I have to modify my existing "Empty" function code to make it Lianja compatible.

Can you correct this Lianja ODBC behavior ?

[barrymavin]

Well you already asked on a ticket.

No the ticketing system is specific to your tickets and the thread of interaction with Lianja support.

Your question (2) is specific to using ODBC.

When you submit a ticket it is prioritized as has been previously explained.

It will be looked at in due course.

We are working on a new website and looking at a new help desk system for when v2.0 is released.