AutoIncField Problem???

qhwq · Post by **qhwq** » 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

Ikar · Post by **Ikar** » 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.

qhwq · Post by **qhwq** » 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

Ikar · Post by **Ikar** » 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