>>>We are not using the DE, so that should not be a problem for us. We are using a function to get a newkey for the keys in the cursorschema (just like we did with SQL views). BTW, I think there is an article from Calvin Hsia somewhere that describes how to get the key from the backend when its generated by the database itself.
>>
>>If you found the link ... I found CAs without a DE hard to handle, since they can only be contained in a DE?
>
>It actually was from aleksey... his solution can be found here http://www.foxite.com/archives/problem-with-insert-in-ado-cursoradapter-0000187776.htm
>
>Walter,

Hi Walter,

this is interesting.

Problem is that I can not use AUTOINC without major changes. I use a StoredProc.
It would need something like

InsertCmdRefreshcmd="select p_Ix from table1 where p_Ix=GetLast('table1')]" 
InsertCmdRefreshFieldList="p_Ix" 

Problem is that GetLast is a bit complex and will be called over and over.

It is not complex to insert a record. But if I insert 1000 records to an empty table it will be called 502500 times.

The CA tableupdate (insert) record per record and the INSERTCMDREFRESHCMD will be called for every record.
Somehow I need to have a SELECT that reduces the number of calls to one call per SELECT call.

offtopic:
One would expect 500500 but somehow the CA add two extra calls per record. This seems to be a general problem of SELECT SQL, it even calls the function twice if no record is available.

Agnes

Update
http://www.foxite.com/archives/autoincrement-and-default-values-ca-0000121281.htm

also deals with the problem