Identity bug

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

Identity bug

Post by Frenk » Sat 15 Apr 2006 09:17

I found one bug with identity field. Reproducable case is:
1.) create a table with identity field
2.) create a view with join to table with identity field
3.) write SQL in TMSQuery from created view and another table

You will see that SQL generation section in designtime, identity field dissapeared. This also happen when you create yoin with sql "inlining" inside TMSQuery.SQL. Can this be fixed?

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Mon 17 Apr 2006 08:47

SQL Generator has some restrictions. It can't generate INSERT, UPDATE, DELETE, REFRESH statements for queries with joins.

Post Reply