Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto-Increment Keys and LOCAL VIEWS
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Auto-Increment Keys and LOCAL VIEWS
Divers
Thread ID:
00949619
Message ID:
00949619
Vues:
86
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform