Date settings Via Lianja ODBC

[naeempk]

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

[yvonne.milne]

Hi Naeempk,

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

Regards,

Yvonne

[naeempk]

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

[yvonne.milne]

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

[naeempk]

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