Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updateable remote views with compound keys
Message
 
 
À
13/06/2011 11:29:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01514226
Message ID:
01514231
Vues:
50
>It's been a while so please help me wrap my head around this.
>
>I want to use updateable remote views against a sql backend that has compound integer keys on some of its tables.
>
>In this case I have a remote view that joins Product_in_Future_Change with Product on Product_id.
>
>But Future_change_id and product_id make up a compound key on PFC, which is the table will be updating.
>
>For purposes of pulling data to be updated with this view I want all the records with a FC_id ( ie. for all products )
>
>Of course I will not be changing the prod_id in the record
>
>When I save to the backend from this view, does the sql passthrough that gets sent know I am using the compound key in order to match my record with the record on the backend?
>
>(It would seem they should but in the past I have always been able to design my own schema and I hold as an article of faith that compound keys are almost as evil as non-surrogate keys )
>
>TIA

I don't see why it should be a problem. If you set your key correctly, then, IMHO, it does not matter if the key is compound or single field.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform