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:
01191638
Views:
23
>>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.

That's a problem since my parameter is an ID, which I don't know. E.g. I have a new record and I save it, how now can I refresh to show this AutoInc (default) value?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform