ODBC Date Format

[Jimmy]

hi,

i notice that Sample c:\fwh\samples\testodbc.prg show DATE as YYYY-DD-MM
i have SET DATE GERMAN but it does not help

how to use ODBC and GERMAN Date Format

[nageswaragunupudi]

That is a character value
You con covert to date with

Code: Select all  Expand view

dDate := FW_Str2Dt( strDate )

Please see:

Code: Select all  Expand view

  oDbf:lDateAsStr := .t.

at line 95 of testodbc.prg

[Jimmy]

hi,

That is a character value

Please see:

Code: Select all  Expand view

     oDbf:lDateAsStr := .t.

at line 95 of testodbc.prg

ok, thx

when set .F. and use SET DATE GERMAN it display right

[nageswaragunupudi]

I don't know.
Haven't touched ODBC for a very long time.