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