>>>>>Ok, I'm back to square one with the original problem of AutoInc field <g> Since I'm using VFP8, I save the current ID by reading it from the table in AfterInsert and in my Save method I replace ID with the saved ID in CA.Alias and reset setfldstate for the PK field. Somehow it's not enough and I now get this error message. So, the question goes back - how can I "refresh" my CA AutoInc field in VFP8.
>>>>
>>>>Didn't you decide that AfterInsert is not safe and so you will use 'nextid'?
>>>
>>>I changed my mind <g>, but looks like I just prolonged the agony...
>>
>>Frankly, I read these cursoradapter threads with some level of amusement that so much stuff is needed for rather simple interface. One should wonder how was it possible to write VFP applications before cursoradapter appeared.
>
>They are supposed to make your life easier if you know how to use them... <g>
It looks like a philosophical justification. Being in technical field makes me sceptical to such arguments.
Edward Pikman
Independent Consultant