Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto-increment field and Cursor Adapter
Message
From
11/01/2007 11:48:08
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01184627
Message ID:
01184631
Views:
24
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>I'm using VFP Autoincrement fields for my PKs. I want to display this auto-generated PK on the form. However, using append blank doesn't create a key up until the record is actually saved.
>
>What can I do to display the PK on the form, but yet not making changes in the record?
>
>Thanks in advance.
>
>After second thought, it may be impossible, since the number may change if another user makes updates.

It can be very confusing if actually saved ID will be different from one you could show on the screen. I would show 'New' in PK textbox, if it's really needed to show PKs at all.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform