Devart Forums

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

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