...
Finally, add the UDF columns to the _as_UserDefinedFields definition table.
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
INSERT INTO [dbo].[_as_UserDefinedFields]
([CreationDate]
,[LastUpdateDate]
,[CreatedOnDate]
,[LastModificationDate]
,[FieldName]
,[Description]
,[PageIndex]
,[DataType]
,[SortOrder]
,[FieldSize]
,[ForceValue]
,[DecimalPlaces]
,[DataBaseTableName]
,[IsVisible])
select
getdate()
,getdate()
,getdate()
,getdate()
,fieldname
,fieldname
,0
,udfDataType
,0
,max_length
,0
,scale
,'loans2'
,1
from udf_columns |
...