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