Identity bug

Frenk · Post by **Frenk** » Sat 15 Apr 2006 09:17

Hi,
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?
Regards,
Frenk

Jackson · 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.