FiveTech Software tech support forums

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

hi,

nageswaragunupudi wrote: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

hi,

nageswaragunupudi wrote:Using fwh\samples\access.prg, the msaccess database of Read/Write.
We revised access.prg and here it is:

Please copy this program to 32-bit fwh\samples folder overwriting the existing access.prg and build with

Great, thx

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

Using fwh\samples\access.prg, the msaccess database of Read/Write. We revised access.prg and here it is: #include "fivewin.ch"REQUEST DBFCDXstatic oCn//----------------------------------------------------------------------------//function Main()   local aTables  &nbs...

Jimmy

See this post from Rao ..

viewtopic.php?f=3&t=43349&p=260959&sid=198b72be29b30897851131dbd2d19f91#p260959

Rick Lipkin

hi,

i try c:\fwh\samples\testodbc.prg and c:\fwh\samples\access.prg (BUG ISKINDOF)
i can open "Edit" but all are "read only"

what do i miss

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

Testing.

Wen can create a help text. ex. COPY button (ok)
When you go to a other control (ODBC) it will sometimes show the txt from COPY.
But when you click ODBC, see the menu and return, when you click then, the correct help is shown.

Could it be that the ID is not always correct ?

... is an excellent database choice but for large enterprise apps I like Sql Server. ADO does NOT require any 3rd party connection libraries ( like odbc ) and all the ADO drivers ( connectivity ) are contained on every Microsoft windows 10 workstation .. ADO is very much like the syntax of TDatabase ...

... for it but it "seems" it is not "free" for PostgreSQL any more Microsoft introduced ADO as an advancement over ODBC. ADO is designed work both with ODBC drivers and OLEDB providers. We need not have OLEDB provider to use ADO. We can use ADO with ODBC drivers ...

... even in PgAdmin next is to "browse" and "navigate" ... when using ADODB i got Method to "navigate" but how with ODBC :?: for my "native" Solution i use Listview and a "Cursor" which is "LIMITed" to Size of "Browse" so i ...

As Rao mentions ODBC is a thing of the past .. specifically, lets say I have a corporate SQL application that needs to run on 3000 machines .. that means that (someone ) has to physically go to each of those machines and make sure ...

Do you mean you want to connect using ODBC driver natively and not through ADO? You can do it, though it is a thing of the past. FWH provides todbc.prg and todbcrdd.prg and more You can also test TOdbcDirect class in tdbodbcd.prg To be honest, ...

... and "ADODB.Recordset" it is easy to "navigate" as "ADODB.Recordset" have Method for it Question : what to use with ODBC or "native" :?: "normal" i would say : fill Array with "Result" ... is there a "other" Way :idea: