Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt View ?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00213432
Message ID:
00213523
Views:
32
To follow-up, the problem is the designer nests the joins. You can use the designer to create the view initially, but before you exit the designer, view the SQL generated, and copy the code to a PRG. Un-nest the joins then run the PRG. e.g.,
FROM Travel!TravAuth ;
  LEFT OUTER JOIN Travel!Roster ;
    ON TravAuth.EmpId = Roster.EmpId ;
  LEFT OUTER JOIN Travel!Accounts ;
    ON TravAuth.ActId = Accounts.ActKey
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform