>>While I was doing the safe select into this 3rd bizobject's CA (i.e. senduptates=.f., zap, select into a temp cursor, append from it, all of a sudden the .sendupdates=.t. and this append is now an insert, immediately sent to server, key constraint violation, bang. Tried to work around this in several ways, and in the end only .cursorfill with a new .selectCmd worked.
>
>sql session is the same ?
>check sql traffic with sql profile.
There's only one session in this case, and since the CA does the auditing also, somewhere in beforeupdate/insert/delete, I get the trace of what was happening - it audits the insert even if it fails.