Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote views of Oracle Database
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00228086
Message ID:
00228943
Vues:
11
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform