VFP and ODBC


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: VFP and ODBC

  1. #1
    richardl Guest

    VFP and ODBC


    Does anybody out there know ANY good reference on using DBF files with the
    Microsoft Visual Foxpro Driver in Visual Basic??

    Specifically, DBF and CDX as flat files, not as DBC files.

    More specifically, how to specify the tag in the CDX when opening a DBF.

    Doing an SQL query against a DBF is SO SLOW.

    Help! Help!

  2. #2
    Craig Berntson Guest

    Re: VFP and ODBC

    There is a help file that accompanies the ODBC driver. On my computer it's
    VFPODBC.txt. There is also additional information in the VFP docs, available
    at msdn.microsoft.com/library.

    Note that you don't specify the index tag when using the ODBC driver. All
    access is via SQL SELECT commands.

    --
    Craig Berntson
    MCSD, Visual FoxPro MVP
    www.craigberntson.com
    Salt Lake City Fox User Group
    www.slcfox.org
    Visit FoxCentral www.foxcentral.net
    ---


    "richardl" <richardl@astralc.com> wrote in message
    news:3c3e3c2a$1@147.208.176.211...
    >
    > Does anybody out there know ANY good reference on using DBF files with the
    > Microsoft Visual Foxpro Driver in Visual Basic??
    >
    > Specifically, DBF and CDX as flat files, not as DBC files.
    >
    > More specifically, how to specify the tag in the CDX when opening a DBF.
    >
    > Doing an SQL query against a DBF is SO SLOW.
    >
    > Help! Help!




  3. #3
    richardl Guest

    Re: VFP and ODBC


    SQL Select is TOO SLOW.

    Some of my DBF files are over 1GB, and most are over 250MB.

    The strain on my CPU is terrible. I need a faster way to do this.


    "Craig Berntson" <craig@craigberntson.com> wrote:
    >There is a help file that accompanies the ODBC driver. On my computer it's
    >VFPODBC.txt. There is also additional information in the VFP docs, available
    >at msdn.microsoft.com/library.
    >
    >Note that you don't specify the index tag when using the ODBC driver. All
    >access is via SQL SELECT commands.
    >
    >--
    >Craig Berntson
    >MCSD, Visual FoxPro MVP
    >www.craigberntson.com
    >Salt Lake City Fox User Group
    >www.slcfox.org
    >Visit FoxCentral www.foxcentral.net
    >---
    >
    >
    >"richardl" <richardl@astralc.com> wrote in message
    >news:3c3e3c2a$1@147.208.176.211...
    >>
    >> Does anybody out there know ANY good reference on using DBF files with

    the
    >> Microsoft Visual Foxpro Driver in Visual Basic??
    >>
    >> Specifically, DBF and CDX as flat files, not as DBC files.
    >>
    >> More specifically, how to specify the tag in the CDX when opening a DBF.
    >>
    >> Doing an SQL query against a DBF is SO SLOW.
    >>
    >> Help! Help!

    >
    >



  4. #4
    Craig Berntson Guest

    Re: VFP and ODBC

    Then you don't have proper indexing or too many deleted records or both.

    --
    Craig Berntson
    MCSD, Visual FoxPro MVP
    www.craigberntson.com
    Salt Lake City Fox User Group
    www.slcfox.org
    Visit FoxCentral www.foxcentral.net
    ---


    "richardl" <richardl@astralc.com> wrote in message
    news:3c3ef459$1@147.208.176.211...
    >
    > SQL Select is TOO SLOW.
    >
    > Some of my DBF files are over 1GB, and most are over 250MB.
    >
    > The strain on my CPU is terrible. I need a faster way to do this.
    >
    >
    > "Craig Berntson" <craig@craigberntson.com> wrote:
    > >There is a help file that accompanies the ODBC driver. On my computer

    it's
    > >VFPODBC.txt. There is also additional information in the VFP docs,

    available
    > >at msdn.microsoft.com/library.
    > >
    > >Note that you don't specify the index tag when using the ODBC driver. All
    > >access is via SQL SELECT commands.
    > >
    > >--
    > >Craig Berntson
    > >MCSD, Visual FoxPro MVP
    > >www.craigberntson.com
    > >Salt Lake City Fox User Group
    > >www.slcfox.org
    > >Visit FoxCentral www.foxcentral.net
    > >---
    > >
    > >
    > >"richardl" <richardl@astralc.com> wrote in message
    > >news:3c3e3c2a$1@147.208.176.211...
    > >>
    > >> Does anybody out there know ANY good reference on using DBF files with

    > the
    > >> Microsoft Visual Foxpro Driver in Visual Basic??
    > >>
    > >> Specifically, DBF and CDX as flat files, not as DBC files.
    > >>
    > >> More specifically, how to specify the tag in the CDX when opening a

    DBF.
    > >>
    > >> Doing an SQL query against a DBF is SO SLOW.
    > >>
    > >> Help! Help!

    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center