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
Miscellaneous
Thread ID:
00949619
Message ID:
00949690
Views:
11
The first think that comes to my mind is to REQUERY the view after TableUpdate(). Unfortunately nothing else :o(((



>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!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform