Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationships or SQL queries?
Message
From
08/11/2018 16:45:31
 
 
To
02/11/2018 13:40:29
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:
01663221
Views:
49
Likes (1)
>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).

An obvious situation where I've resorted to SET RELATION is when a table logically would've contained more than 254 columns.
Previous
Reply
Map
View

Click here to load this message in the networking platform