Devart Forums

Hello,

In one table I'm trying to change primary key field instead of AutoInc to Guid. On insert Guid field is generating on the server. The problem is that I do not find how to return the inserted Guid. With AutoInc everything is working well.

I forgot to type what error occuring:
"Operand type clash: numeric is incompatible with uniqueidentifier"

SQL server doesn't allow this functionality. You should refresh a table to solve the problem.

If I understad where is one way:

1. Generate Guid on clinet side
2. Insert
3. Refresh
4. Use Locate to find and set cursor on inserted record

???

If you generate GUID on client side, you don't need to refresh dataset and to find inserted record, because after inserting cursor is located on this record.

Thank you.