Re: Using Visual FoxPro indexes from Visual Basic .Net

Hi cj:

Why don't you use VFP automation? Just create a VFP automation object and
use the tables and indexes through it.
Just remember to use the DoCmd() command to execute commands and use Eval()
to execut functions.

Example (inVFP):
oo = createobject("visualfoxpro.application")
oo.DoCmd("USE D:\DESARROLLO\TABLE1")
*-- Get the FieldNames
FOR i = 1 TO oo.Eval("FCOUNT()")
? oo.Eval("FIELD(" + STR(i) + ")")
ENDFOR
*-- Get the value of the field named "N_VAL"
? oo.Eval("N_VAL")
*-- Go to record 2
oo.DoCmd("GOTO 2")
? oo.Eval("N_VAL")


Regards,

Fernando D. Bozzo
VFP6/SP5
Madrid/Spain



"cj" <cj@xxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el mensaje
news:BFC32F9B-8425-4FDB-A714-02DFFD0526C6@xxxxxxxxxxxxxxxx
> I have to access several visual foxpro stand alone tables from within
VB.Net
> and it's slowwww. The VFP tables have indexes but how or can I get VB to
use
> them?


.

Loading