Generate the PK in your app.

>I created a SPT cursor and make it updatable.
>If adding new rows using tableupdate(), SQL server fills the primary key fields.
>
>I want to get back filled primary key values to SPR cursor because the update conflict error occurs otherwise.
>
>I tried

REQUERY('mysptcursor')

>
>but this returns
>
>Function not supported for SQL pass-through cursors (Error 1504)
>
>refresh() function does not return error but does not do anything.
>
>I have read from somewhere that it is possible to use REQUERY() with SPT cursors.
>
>Any idea ?
>
>Andrus.