Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationships or SQL queries?
Message
From
08/11/2018 10:05:43
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01663090
Message ID:
01663201
Views:
59
>>I'm curious how many people here use SET RELATION data relationships for viewing parent/child local data, as compared to SQL queries / views which load everything into a single file? I've observed that most old school developers (began in the 80s) use SET RELATION, and most newer developers prefer SQL almost exclusively (and I think many would prefer LINQ).
>
>I use SET RELATION in/to local cursor in reports with 2 data bands.

Haven't used set relation in a long time. I do often use lookup() to get descriptions from code fields to cut down on the SQL.
Previous
Reply
Map
View

Click here to load this message in the networking platform