>That's good, but why the other method didn't work? What exactly was wrong?

I guess the following should tell CA to automatically update the id in the VFP cursor

?"1) Refresh IDENTITY field using [SELECT @@IDENTITY] command"
oCA.InsertCmdRefreshFieldList="f_IDENTITY"
oCA.InsertCmdRefreshCmd="SELECT @@IDENTITY"

I did the following in the builder built class

lAutoRefreshNewRecords= .T.
lUseDefaultRefreshCmd= .F.
cInsertCmdRefreshFieldList= acbalid

_BuildDefaultRefreshCmd method as

TEXT TO THIS.InsertCmdRefreshCmd TEXTMERGE NOSHOW PRETEXT 10
	SELECT @@IDENTITY
ENDTEXT

but I still could not locate the mistake till now.
Have you tried Mark E. McCasland's builder? then you may have solved the issue.