Re: FoxPro free table, index, seek, with vb.net

Tech-Archive recommends: Fix windows errors by optimizing your registry

On May 9, 4:29 pm, "Cindy Winegarden" <c...@xxxxxxxxxxxxxxxxxxx>
wrote:
For what it's worth, Matt's real issue is whether he can use the xBase
"Seek" command against a FoxPro table via ODBC or OLE DB. Whether he's
writing that SQL command string in VB, VB.Net, C#, VBA, or anything else
doesn't really matter.

--
Cindy Winegarden
c...@xxxxxxxxxxxxxxxxxxx

VFP OLE DB:http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC:http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

"Bob Butler" <n...@xxxxxxxxxxx> wrote in message

news:egu$9ljkHHA.3388@xxxxxxxxxxxxxxxxxxxxxxx

"Matt Longfield" <mattlongfi...@xxxxxxxxx> wrote in message
news:1178673891.555921.247530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can anyone tell me if you've ever been able to use the seek method in
any form on a foxpro free table in vb.net? ADO, asp.net, odbc,
whatever.

--
You need to ask in a newsgroup with "dotnet" in the name. This group id
for VB 6.0 and earlier and does not include VB.Net or VB 200x.

Thanks for trying to be helpful, Cindy.
You're correct, I don't really care if it's vb6, vb.net, ado, or
whatever.
I can easily transpose from vb.net to vb6 to vfp. Most of my
experience is with vb6 & ado
I was hoping someone had experienced an similar situation and found a
resolution.
just a FYI, I DO have an index with the EXACT expression that I'm sql
selecting for, and it's still very slow.
A VFP5-9 seek happens in under 2 seconds, I was hoping for similar
performance in VBx.
The ONLY solution I've discovered so far is to "wrap" the lookup in a
vfp dll and call that from vb - but I'm still hoping for something
more elegant

Cindy; I've noticed you name in a lot of different groups and posts.
Thanks for your constant efforts to help the newcomer & oldtimer
alike.

Bob; I stand reprimanded.
No more of that nasty vb.net talk to soil your pristine group. I get
it. I guess I slept through posting 101. ESP 101 too.

Nice people ROCK. (Thanks Cindy)
(keep trying Bob, you'll get there one day)





.

Relevant Pages

  • Re: IS PostgreSQL suitable in VFP Application
    ... end to any ODBC or OLE DB compliant database, ... the VFP ODBC driver or OLE DB data provider. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: IS PostgreSQL suitable in VFP Application
    ... to any ODBC or OLE DB compliant database, ... You don't use the VFP ODBC driver ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Zugriff auf die VFP-DB per ODBC oder OLEDB ?
    ... vom OLE DB Treiber geliefert wird zunächst mal in ein ADO Recordset umgewandelt werden muss. ... Das VFP Entwicklungsteam wurde bereits gebeten, eine aktuelle Version des VFP ODBC Treibers zur ...
    (microsoft.public.de.fox)
  • Re: IS PostgreSQL suitable in VFP Application
    ... The main concern is if i distribute VFP application with MSSQL ... end to any ODBC or OLE DB compliant database, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: which programming language ?
    ... > Christophe - ... > I can't think of ONE other non-xbase-derived language that will open it ... > odbc. ... > I don't see data access as a limitation with VFP. ...
    (microsoft.public.fox.programmer.exchange)