[Microsoft][ODBC dBase Driver] Index not found

I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to the
tables and run simple queries using ADO. The following query works fine:

SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
BM.BNO, BM.BNAME,
PROD.SPROD, PROD.PROD, PROD.DBTYPE,
CUST.CNO, CUST.CNAME
FROM PROD, CUST, BM, BMX
WHERE BM.BNO = BMX.BNO
AND PROD.PNO = BMX.PNO
AND CUST.CNO = BM.SCNO
ORDER BY PROD.SPROD

But when I insert this line in the Query, I get this message:

[Microsoft][ODBC dBase Driver] Index not found

Line inserted:

AND BMX.BNO = 199

Does anyone have any idea what's going on and if there's a fix or work-around?

Thanks,

Keith

Fred
Sun Mar 16 01:53:05 CDT 2008

Is BMX.BNO a numeric fields or is it a character field?

--
Fred
Microsoft Visual FoxPro MVP


"kflash" <kflash@discussions.microsoft.com> wrote in message
news:2E1CC9A0-C464-4057-9DCF-67C81607483F@microsoft.com...
> I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to the
> tables and run simple queries using ADO. The following query works fine:
>
> SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
> BM.BNO, BM.BNAME,
> PROD.SPROD, PROD.PROD, PROD.DBTYPE,
> CUST.CNO, CUST.CNAME
> FROM PROD, CUST, BM, BMX
> WHERE BM.BNO = BMX.BNO
> AND PROD.PNO = BMX.PNO
> AND CUST.CNO = BM.SCNO
> ORDER BY PROD.SPROD
>
> But when I insert this line in the Query, I get this message:
>
> [Microsoft][ODBC dBase Driver] Index not found
>
> Line inserted:
>
> AND BMX.BNO = 199
>
> Does anyone have any idea what's going on and if there's a fix or
> work-around?
>
> Thanks,
>
> Keith
>

kflash
Sun Mar 16 07:42:01 CDT 2008

BMX.BNO is a Numeric field.

Whatever I try to filter on, I get the same message. If I try to filter
on a character field such as:

And BMX.BMNum = '1015552'

Any suggestions?




"Fred Taylor" wrote:

> Is BMX.BNO a numeric fields or is it a character field?
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "kflash" <kflash@discussions.microsoft.com> wrote in message
> news:2E1CC9A0-C464-4057-9DCF-67C81607483F@microsoft.com...
> > I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to the
> > tables and run simple queries using ADO. The following query works fine:
> >
> > SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
> > BM.BNO, BM.BNAME,
> > PROD.SPROD, PROD.PROD, PROD.DBTYPE,
> > CUST.CNO, CUST.CNAME
> > FROM PROD, CUST, BM, BMX
> > WHERE BM.BNO = BMX.BNO
> > AND PROD.PNO = BMX.PNO
> > AND CUST.CNO = BM.SCNO
> > ORDER BY PROD.SPROD
> >
> > But when I insert this line in the Query, I get this message:
> >
> > [Microsoft][ODBC dBase Driver] Index not found
> >
> > Line inserted:
> >
> > AND BMX.BNO = 199
> >
> > Does anyone have any idea what's going on and if there's a fix or
> > work-around?
> >
> > Thanks,
> >
> > Keith
> >
>
>
>

Fred
Sun Mar 16 12:50:37 CDT 2008

I don't know. It sounds like your index file (.CDX) is posibly damaged.
You'll have to have someone with VFP recreate the indexes.

--
Fred
Microsoft Visual FoxPro MVP


"kflash" <kflash@discussions.microsoft.com> wrote in message
news:AE018C53-A7A9-49DA-9098-F8AF6D0C2CCA@microsoft.com...
> BMX.BNO is a Numeric field.
>
> Whatever I try to filter on, I get the same message. If I try to filter
> on a character field such as:
>
> And BMX.BMNum = '1015552'
>
> Any suggestions?
>
>
>
>
> "Fred Taylor" wrote:
>
>> Is BMX.BNO a numeric fields or is it a character field?
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "kflash" <kflash@discussions.microsoft.com> wrote in message
>> news:2E1CC9A0-C464-4057-9DCF-67C81607483F@microsoft.com...
>> > I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to
>> > the
>> > tables and run simple queries using ADO. The following query works
>> > fine:
>> >
>> > SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
>> > BM.BNO, BM.BNAME,
>> > PROD.SPROD, PROD.PROD, PROD.DBTYPE,
>> > CUST.CNO, CUST.CNAME
>> > FROM PROD, CUST, BM, BMX
>> > WHERE BM.BNO = BMX.BNO
>> > AND PROD.PNO = BMX.PNO
>> > AND CUST.CNO = BM.SCNO
>> > ORDER BY PROD.SPROD
>> >
>> > But when I insert this line in the Query, I get this message:
>> >
>> > [Microsoft][ODBC dBase Driver] Index not found
>> >
>> > Line inserted:
>> >
>> > AND BMX.BNO = 199
>> >
>> > Does anyone have any idea what's going on and if there's a fix or
>> > work-around?
>> >
>> > Thanks,
>> >
>> > Keith
>> >
>>
>>
>>

swdev2
Sun Mar 16 14:44:14 CDT 2008

Have you tried changing your driver ?
The index for FP 2.6 tables is NOT dbase compliant.
There's another FoxPro odbc driver you can use for
foxpro 2.0 to 2.6 tables. It's old, it's outdated, but then
it should fit into your dev environment (and no, that wasn't a dig on yer
toolsets).

There is also a sql window/query tool inside of dbf2000 - see
http://www.dbf2002.com for more info.
If this query works with the dbf2002 set, then you're absolutely using the
wrong ODBC driver
for this project.

Regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"kflash" <kflash@discussions.microsoft.com> wrote in message
news:2E1CC9A0-C464-4057-9DCF-67C81607483F@microsoft.com...
> I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to the
> tables and run simple queries using ADO. The following query works fine:
>
> SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
> BM.BNO, BM.BNAME,
> PROD.SPROD, PROD.PROD, PROD.DBTYPE,
> CUST.CNO, CUST.CNAME
> FROM PROD, CUST, BM, BMX
> WHERE BM.BNO = BMX.BNO
> AND PROD.PNO = BMX.PNO
> AND CUST.CNO = BM.SCNO
> ORDER BY PROD.SPROD
>
> But when I insert this line in the Query, I get this message:
>
> [Microsoft][ODBC dBase Driver] Index not found
>
> Line inserted:
>
> AND BMX.BNO = 199
>
> Does anyone have any idea what's going on and if there's a fix or
work-around?
>
> Thanks,
>
> Keith
>

Fred
Sun Mar 16 13:53:33 CDT 2008

Thanks, I didn't even notice the fact that it was the dBase ODBC driver.

--
Fred
Microsoft Visual FoxPro MVP


"swdev2" <wsanders@dotnetconversions.bob.com> wrote in message
news:Oq3MsU5hIHA.4684@TK2MSFTNGP06.phx.gbl...
> Have you tried changing your driver ?
> The index for FP 2.6 tables is NOT dbase compliant.
> There's another FoxPro odbc driver you can use for
> foxpro 2.0 to 2.6 tables. It's old, it's outdated, but then
> it should fit into your dev environment (and no, that wasn't a dig on yer
> toolsets).
>
> There is also a sql window/query tool inside of dbf2000 - see
> http://www.dbf2002.com for more info.
> If this query works with the dbf2002 set, then you're absolutely using the
> wrong ODBC driver
> for this project.
>
> Regards [Bill]
>
> --
> ===================
> William Sanders / EFG VFP / mySql / MS-SQL
> www.efgroup.net/vfpwebhosting
> www.terrafox.net www.viasqlserver.net
>
> "kflash" <kflash@discussions.microsoft.com> wrote in message
> news:2E1CC9A0-C464-4057-9DCF-67C81607483F@microsoft.com...
>> I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to
>> the
>> tables and run simple queries using ADO. The following query works
>> fine:
>>
>> SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO,
>> BM.BNO, BM.BNAME,
>> PROD.SPROD, PROD.PROD, PROD.DBTYPE,
>> CUST.CNO, CUST.CNAME
>> FROM PROD, CUST, BM, BMX
>> WHERE BM.BNO = BMX.BNO
>> AND PROD.PNO = BMX.PNO
>> AND CUST.CNO = BM.SCNO
>> ORDER BY PROD.SPROD
>>
>> But when I insert this line in the Query, I get this message:
>>
>> [Microsoft][ODBC dBase Driver] Index not found
>>
>> Line inserted:
>>
>> AND BMX.BNO = 199
>>
>> Does anyone have any idea what's going on and if there's a fix or
> work-around?
>>
>> Thanks,
>>
>> Keith
>>
>
>