Devart Forums

Posted: **Fri 28 Jan 2005 13:58**

AutoIncField is used in my SQL Server Database,
"SET :1 = SCOPE_IDENTITY()" is used in SQLInsert Of TMSQuery
but it is unavailable
I can not get the value of AutoIncField After Execute InsertAction
because "refresh failed, found 0 records
why
help me please
thank for you

Posted: **Fri 28 Jan 2005 14:06**

This error happens if none of records was updated - no record suits for UPDATE clause or no field was modified. You can turn off this message. Please refer to help TCustomMyDataSet.Options.StrictUpdate.

Posted: **Fri 28 Jan 2005 15:17**

the meaning of my question is:
TMSQuery can not get get the value of autoincfield in sqlserver database
after insert a record by "SCOPE_IDENTITY()" in SQLInsert of TMSQuery

Posted: **Mon 31 Jan 2005 10:28**

Please send us by email complete example with description of the problem.

Devart Forums

AutoIncField Problem???

AutoIncField Problem???

Re: AutoIncField Problem???

SCOPE_IDENTITY() is usable ? i mistrust it

Re: SCOPE_IDENTITY() is usable ? i mistrust it