I've done quite a bit work with VFP tables with .NET.
I run the VFP queries first from the VFP command window to get an idea of the performance I'll get and to see whether there is any Rushmore optimization.
You'll get roughly the same performance with the same query with OLEDB.
>That's what I'm doing now.
>
>The app reads PDF's full of invoice payment information into into VFP tables. It looks up the invoice in one table, then writes the payment data to other VFP tables.
>
>The client reported that the application took 6 hours to complete, so I need to find a way to speed it up.
>
>
>
>>You won't do it that way. You'll use the VFP OLEDB provider and do everything through SQL statements
>>
>>>I have a C# WPF application that needs to read/write from VFP tables.
>>>
>>>What's the syntax for setting an index and doing a SEEK from within C#?
>>>
>>>Thanks
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.