>>Hi Anton,
>>
>>Ed's idea worked for me, but I found a serious flaw in my implementation. When I designed my database (native VFP), I took AutoInc for my PKs. HUGE mistake! Now I'm in a catch 22 situation, because after I inserted a new record in a table I can not get my PK back. It looks like I have to switch to NextID() for now and use GUID in all other new projects instead.
>>
>If I understand correctly the problem is not with Autoinc itself. You cannot retireve new id because CursorAdapter doesn't return it, correct? VFP9 Help implies that AfterInsert event could be used (actualy it says for ADO source), i.e. record pointer didn't move yet.
How exactly would I take it in VFP9? Also here we're currently using VFP8, should I tell my users to wait till we get VFP9?
If it's not broken, fix it until it is.
My Blog