SqlDbx Forum

alberto.martinez

Member

Suggestion: Ignore calculated fields when generating INSERTs

Hello,

  When SqlDbx exports data from SQL Server as Inserts, it does include calculated fields in the field list, making the inserts generated unusable because as you might imagine SQL Server won't allow updating calculated fields.

  This could be solved ignoring those fields when generating inserts, which is pretty straightforward since that fields have "iscomputed" set to 1 in the syscolumns table (I did something similar for a internal app sometime ago).

  Regards.

sqldbxhelp

Administrator

Re: Suggestion: Ignore calculated fields when generating INSERTs

I will need to check this one. I thought it was fixed some time ago