Results 1 to 5 of 5

Thread: Date settings Via Lianja ODBC

  1. #1
    Member
    Join Date
    Feb 2012
    Posts
    43

    Date settings Via Lianja ODBC

    Hi,

    1) What will be the date format of a Lianja table if record is inserted through Lianja ODBC ? For example in oracle this setting can be set on current session or database level.


    2) What is the default the century setting ?

    Regards
    Naeem

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Hi Naeempk,

    Lianja ODBC uses ISO format dates: YYYY-MM-DD; Century is ON.

    Regards,

    Yvonne

  3. #3
    Member
    Join Date
    Feb 2012
    Posts
    43
    Hi,

    I tried to update date field in my Lianja table from VFP 9.0 sp2 through Lianja ODBC and my date setting was YMD. The command is

    ? sqlexec(lnConnHandle, "update mytable set dated = {2015/05/14 09:29:02}")

    The command is successfully executed but when I fetched data from Lianja table, it showed NULL is saved in my table.

    If I save {2015-05-14 09:29:02} then the datetime value is stored perfectly. Is there a way to set date mark '-' to '/' for Lianja ODBC ?

    Regards
    Naeem

  4. #4
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Hi Naeem,

    Dates are set to ISO internally, so you would need to convert the value you are sending, e.g.

    ctot(strtran("2015/05/14 09:29:02","/","-"))

    Regards,

    Yvonne

  5. #5
    Member
    Join Date
    Feb 2012
    Posts
    43
    Hi,

    Thanks for your reply. I had already done this. But there should be some Lianja ODBC setting which can make easy database level settings.

    I am trying to set manual transaction property for Lianja ODBC connection. I got this error

    "Warning: The connection transaction mode cannot be set."

    How can I set this ?

    Regards
    Naeem

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