>This is in relation to my post under Client/Server. I'm still new to SQL Server so the suggestion I was given isn't yet in my ability to do in a reasonable timeframe. Does anyone know if you can set a field to be incremental in a CursorAdapter's Cursor Schema property if on the backend (in this case SQLServer) the field isn't Incremental but still an int?
>
>Such as:
>
>Field1 C(10), Field2 C(3), Field3 I AutoInc Nextvalue 1 step 1, Field 4 C(5)....
>
>
>TIA
>Richard

I don't think so. However you could cheat creating a cursor with autoinc value and inserting into it first. Then get the inc'ed value from it.
PS: i don't have an idea what would you do with such a value.
Cetin