#19 Error retrieving FoxPro logical fields

open
nobody
None
5
2004-11-22
2004-11-22
Don Geiger
No

Hello.

I am trying to use the Open source dbExpress driver to
access legacy data through the Microsoft Visual FoxPro
driver. Everything seems to be working great except
that all logical fields evaluate to True, regardless of their
actual value.

I think that this may be due to the stupid way that DBF
files store logical values - .T. for true, and .F. for false.

I can get a small demonstation project to you, if that
would help.

Thanks

Don

Discussion

  • Logged In: YES
    user_id=644745

    Send an example to the address pult@ukr.net

     
  • Logged In: YES
    user_id=644745

    I could not receive your problem with your test app.
    For work with FoxPro (test.dbf) i used:

    Visual FoxPro ODBC Driver (6.1.8629.1): http://msdn.
    microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
    Download direct link:
    [http://download.microsoft.
    com/download/vfoxodbcdriver/Install/6.
    1/W9XNT4/EN-US/VFPODBC.msi]

     
  • Logged In: YES
    user_id=644745

    I could not receive your problem with your test app.
    For work with FoxPro (test.dbf) i used:

    Visual FoxPro ODBC Driver (6.1.8629.1): http://msdn.
    microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
    Download direct link:
    [http://download.microsoft.
    com/download/vfoxodbcdriver/Install/6.
    1/W9XNT4/EN-US/VFPODBC.msi]