Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a View
Message
From
18/03/1999 14:23:32
 
 
To
18/03/1999 14:19:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00199394
Message ID:
00199396
Views:
18
>Is it possible to index a view. I have crated a view, brought it into the report designer. I want to set a relation from a field from another table in the report that would drive a key field in the view. The view designer lets me set an order, but when I try to drag the relation line in the designer, I find there is no index in the view I created. I am new at this, so forgive me if this is really stupid.

You may index a view the same way as table:
Select MyView
=cursorsetprop("buffering",3) && if it's not 3 yet
Index On myfield Tag myfield
Now you may use SET RELATION
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform