VFP and ODBC

[richardl]

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!

[Craig Berntson]

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!

[richardl]

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!
>
>

[Craig Berntson]

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!
> >
> >
>