Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto-Increment Keys and LOCAL VIEWS
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Auto-Increment Keys and LOCAL VIEWS
Miscellaneous
Thread ID:
00949619
Message ID:
00949619
Views:
87
Hello All,

I've got a mentoring client who is having a problem with LOCAL VIEWS and auto-increment fields in VFP 8. Since I haven't worked with the auto-increment fields in VFP 8 yet, I come here looking for help!

USE vCustomer NODATA && assume two fields PKID (auto-inc) and CompanyName
CURSORSETPROP("Buffering",3)
APPEND BLANK

* At this point the PKID field in the view has 0 and that makes sense

REPLACE CompanyName WITH "TakeNote Technologies"

After a TABLEUPDATE(0) the parent table shows the new key value but the LOCAL VIEW does not. What is the best way to get that value into the LOCAL VIEW? Something like this?

vCustomer.PKID = Customer.PKID

Thanks!
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Next
Reply
Map
View

Click here to load this message in the networking platform