Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two way view designer question
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Two way view designer question
Miscellaneous
Thread ID:
00719319
Message ID:
00719319
Views:
36
I just fired up the view designer and added two tables from the Northwind database (Categories and Employees). I added a few fields to the query, and added a filter "Categories.categoryname = 'Hello'" from the designer. Then I brought up the SQL code to try out the two-way option. I modified the line: Categories.categoryname = "Hello" to read: Categories.categoryname = "HelloThere" , then I tried to close the window, assuming it would update the view designer. Instead, I get the error "There is a duplicate table alias 'EMPLOYEES' in the FROM clause", and another "View/Query designer is unable to reload your changes. Would you like to rebuild content from designer?". Am I misunderstanding how this is supposed to work?
-Paul

RCS Solutions, Inc.
Blog
Twitter
Next
Reply
Map
View

Click here to load this message in the networking platform