Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improving sluggish SQL
Message
From
21/12/1999 00:50:37
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00306158
Message ID:
00306553
Views:
30
>Walter,
>
>The problem with your suggested code is this;
>
>
>USE TABLE1 && Opens table1 in the currently selected work area
>
>USE TABLE2 ORDER TAG keyfieldTag && Opens table2 in the currently selected
>                                 && work are closing Tbale1
>
>SET RELATION TO Keyfield INTO Table2 && Sets a relation from the currently
>                                     && selected work are into Table2 whihc is
>                                     && open in the currently selected work area
>
>BROWSE NORMAL FOR EOF("Table2")
>
Jim, yes as you would probably noticed, ed has corrected me already, seems I was just in a hurry, nut i'll bet you've got the idea.

regards,

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform