Results 1 to 4 of 4

Thread: Empty or Null datetime values return problem Via Lianja ODBC

  1. #1

    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

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,719
    Blog Entries
    17
    This is a replica of a ticket already submitted. Replies are being made on the ticket.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    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 ?

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,719
    Blog Entries
    17
    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.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us