Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Modifying Screens from VFP-DBC to Oracle remote views
Message
 
À
27/09/2004 16:36:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00946424
Message ID:
00946432
Vues:
25
>I have converted data base tables to Oracle. I have also created the PK, FK and indexes in Oracle. I removed the VFP 7.0 tables from by DB container and added remote views for each table, When modifying my form, I changed my data environment to include the remote views of the tables I want. My problem is that I cannot figure out how to establish my relationships so that when I hit the previous and next key that the related tables will change also. I have gotten the form to run, although like molasses, but where data is to come from a relationship, I cannot get it.

Do these remote views have parameters?
It sounds to me like what you've done is simple replace tables with remote views. That's probably not going to work too well because the remote views will be requerrying ALL the records for each table.
If you make some parameterized remote views, you can join tables together in the views to establish relationships....of course you can do this without using parameters, but you'll be having that 'molasses' problem....
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform