>>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