>Hi! I wonder if someone can think of something...
>
>On a form, I call a screen who will serve to build a query (In screen, I have fields in witch I can enter text). The part to build the query is not the speed problem.
>
>The problem is that when I execute the query (The query is in a text variable and I execute it with "&SqlQuery"), it take about 4 1/2 minutes. If I put a suspend command in my code, and then I go in the VFP Command box then I execute the "&SqlQuery" command, it take 15-20 secondes!
>
>I tried to simplify the query as much as I could, I tried to get rid (just to try) of the "&SqlQuery" by having a "code" query insted but I have the same result.
>
>Does any body have a clue?
Do you have exact indexes on every possible field that can go in the Where CLAUSE?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.