Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating local view without primary keys
Message
From
05/05/1999 14:35:22
 
 
To
30/04/1999 17:48:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00214137
Message ID:
00215457
Views:
24
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform