Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: ODBC FoxPro Lost Records

    I'll make this as simple as possible.

    If I open up visual fox pro on a table and run this query...

    "select * from table where code = 'ahp001'"

    it returns 15 rows.

    When I run the same query using a ODBC Driver (Microsoft Visual Fox Pro) It returns nothing!

    Any thoughts, the query is being run against the same DBF File!!

    Thanks

    Scott

  2. #2
    Join Date
    Oct 2003
    Location
    France
    Posts
    10
    Hi,

    You may be need to declare a cursor before and to open it ?

    -vb6dv-

  3. #3
    Join Date
    Jun 2003
    Posts
    24
    Had the same problem a while back. It turns out that i checked the deleted mark in my ODBC driver.

    Hope this helps
    water water everywhere and the boards did shirnk
    water water everywhere not a drop to drink

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •