Hi,

1. I need a computed column in a SQL server table. Is it possible to define it from within DDT?

2. When I create it in SQLServer Management Studio, and import the database in DDT, I can't see that it is a computed column.

Dustin,

I meant the column on the table. So if DDT does know nothing within the scripts, I'll do usual tests, as I used to do.

Thanks again.

Hi Ben, Trent,
Are you considering adding support to SQL Compute Columns to SF 2.0?

I know we can do some work around adding a BO Custom Field Property, but having an SQL Compute Columns field is much more better, faster and easier to use this column no matter how much records you will be working with.

Edhy Rijo

Yes, we do support compute columns in v2.  Any field can be marked as IsAssignedByDbOnInsert and/or IsAssignedByDbOnUpdate (those fields are independent).  Computed columns are flagged True for both of those by default.  Using SQL Server, we use the OUTPUT clause of the INSERT and UPDATE to pull back the values.  Other DBs run a query after the insert or update to get the new values.  Those values are then returned to entity.

Awesome, thanks Ben!!!

Edhy Rijo

Thanks Ben!