Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote views of Oracle Database
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00228086
Message ID:
00228943
Views:
12
>I am trying to create the view using 10+ Oracle tables. Everything seems to go fine until I try to save the view. It does not matter whether I am creating the view visually or programatically. That is when everything stops.
>

WOW! The View designer hoses you if you use more than 3 tables. The best you can do with that is use the designer to get your initial code. You can view the SQL then do a copy and paste of the code into a PRG file. One key point would be to make all your joins sequential instead of nested. I do not envy you having to try to join 10 or more tables. Only once have I had to join as many as 8 Oracle tables. Never again will I have to do that because our Oracle DBAs made Oracle views to do some of this for us.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform