Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List box
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00236826
Message ID:
00237369
Views:
10
>SELECT Child
>SET RELATION field INTO Parent
>
>I want to display all records in child table in the listbox if Parent record is moved.
>
>E.g
>Parent.field_x = "ABCDE"
>I want to display all child.field_x = "ABCDE" in the listbox.
>
>I've thousands record in child table and I can do that with SQL command, but very slow. I don't want to use Grid!
>
>Thanks

If your indexes are set up correctly, both SQL and grids should be very fast. With the grid you can populate the grid with and SQL cursor or view, or you can use the built-in grid properties (linkmaster, etc.) to set relations. The speed of both depends on having the correct indexes, however.
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform