>My ID is SQL is a uniqueidentifier with ROWDID() as default values.
Are you using a GUID as the PK value -- where is ROWDID() coming from?
>I am using Default Mode.
Presume you mean row?
>Yes, I tracked it. It is when I hit the "Save button". But, for some reason I don't know, the new record is in the buffer but not in SQL Server yet. That is why I don't get any value from GetLastPK.
What workarea value is specified in your save button?
>But right after i do a "Browse" to the view, when a new record is there but not saved, I can see the new record in SQL Server.
Browsing the view appears to be just committing any unsaved records, implying that you are row buffered.
>Do you think I should force a tableupdate ?
Definately not! The Codemine update routines work just fine. This is ultimately what they do. I am currently working with CM & SQL server and I am having no problems with it whatsoever.
>Or is it a setting problem in my view (or in the CDE) ?
This is the most likely and probably in the CDE. If browsing the view is committing the records, then the view sounds OK. So, the cursor object's settings in the CDE sound suspect. Maybe you could post the values in the cursor's property sheet - just the ones that have custom values in them (non-default).
Best
-=Gary