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 TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development