G
Glenn Wilson
Hi,
I am currently working on a project in which I need to interrogate a FoxPro
database and present some results from the database in a web browser. I am
using VS.NET 2003, Framework 1.1. I build a Select statement and then use
the Select statement to query a table in the FoxPro database. The problem
is, the query is taking a very long time to run from my .NET code. Running
the same query from inside Visual Fox Pro is 20 times faster. Does anyone
know what I can do from my .NET code to make the query much faster? The
query string I use follows this pattern:
SELECT * FROM myTable WHERE UPPER(myField) = myValue
Thanks in advance
Glenn
I am currently working on a project in which I need to interrogate a FoxPro
database and present some results from the database in a web browser. I am
using VS.NET 2003, Framework 1.1. I build a Select statement and then use
the Select statement to query a table in the FoxPro database. The problem
is, the query is taking a very long time to run from my .NET code. Running
the same query from inside Visual Fox Pro is 20 times faster. Does anyone
know what I can do from my .NET code to make the query much faster? The
query string I use follows this pattern:
SELECT * FROM myTable WHERE UPPER(myField) = myValue
Thanks in advance
Glenn