AutoIncField Problem???

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
qhwq

AutoIncField Problem???

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
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: AutoIncField Problem???

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

SCOPE_IDENTITY() is usable ? i mistrust it

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
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: SCOPE_IDENTITY() is usable ? i mistrust it

Post by Ikar » Mon 31 Jan 2005 10:28

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

Post Reply