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:
01191640
Views:
19
>>>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?

Catch 22 :o)
Native tables or other backend?
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