Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating local view without primary keys
Message
De
05/05/1999 14:35:22
 
 
À
30/04/1999 17:48:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00214137
Message ID:
00215457
Vues:
25
>>I'm looking for a good way to edit invoice rows.
>>
>>First I tried to use a grid based on a table with linkmaster,childorder,relationalexpression properties.
>>For some strange reason, grid displays all rows, not current invoice.
>>
>>Second I created a parametrized local view.
>>However, invoice row table data does not have primary or candidate key so it is not possible to update it using local view !?
>>
>>Which is the best way to edit child records in one to many
>>relationship?
>
>The best way is to create primary key for your child table too. You may add one more integer field there.

Ed,
to do this, I must re-write large portions of code. Also,
the database structure is used by some other applications which
are not under my control so I cannot change its structure.

I can add some temporary field to base table and update it
in some other way, then edit in local view, but is'nt there
a better way?
Andrus
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform