Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AutoInc value and CA
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01191628
Message ID:
01191635
Views:
26
>Hi everybody,
>
>I have a table with an AutoInc field. I have a CA for this table. I start a form in a New mode, so my field is empty. I show "New" in the textbox for the ID field. However, when I save my record, I want to show the actual ID. Should I do CursorRefresh() then or how can I get the actual ID after I saved the record?
>
>BTW, my parameter variable may not be in scope at this time.
>
>Thanks a lot in advance.

Yes, you must CursorRefresh() (and ask for upgrade to VFP9, it has InsertCmdRefreshCmd property), make sure that your parameter IS in scope.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform