Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key differs between view & table
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Key differs between view & table
Miscellaneous
Thread ID:
00332312
Message ID:
00332312
Views:
62
I am using the default framework and basing my view off a joined set of 2 tables. When the view is created, my primary table cust has the proper value, ie next # from table ID. When I do a table update though, the key in CUST is 1 # greater?

v_cust_accnt.custid = 234

cust.custid = 235 for the same record.

Is it because this is a join and it is double pumping the same table in generating id's? accnt.accntid has a different name instead of uid for all the keys.

TIA

__Stephen
Next
Reply
Map
View

Click here to load this message in the networking platform