field.attribute(field.property(defaultvalue) = how to set

[blunt]

Looking for a hint on the proper syntax to set the default value for a string and a Y/N field using the SDK.

Thanks

[jimdurkin]

 Me.FieldDescriptor = New Act.Framework.Database.FieldDescriptor(sFieldName, sFieldName, EntityDescriptor, Act.Framework.Database.FieldDataType.Character)

'---------------------------------------

' STRINGS

'---------------------------------------

 Me.FieldDescriptor.Attributes(Act.Framework.Database.FieldProperty.DefaultValue) = New Act.Framework.Database.DefaultValueAttribute("DefaultstrValue")

'---------------------------------------

' BOOLEAN

 '---------------------------------------

 Me.FieldDescriptor.Attributes(Act.Framework.Database.FieldProperty.DefaultValue) = New Act.Framework.Database.DefaultValueAttribute(True)

Remember to lock the database before adding your field

'---------------------------------------

' LOCK the Database

'---------------------------------------

CommonPlugin.ACTFM.Database.LockDatabase(Act.Framework.DatabaseLockReason.SchemaChanges)

'---------------------------------------

' Save the field changes

'---------------------------------------

CommonPlugin.ACTFM.Fields.Save(Me.FieldDescriptor)

'---------------------------------------

' Unlock the database

'---------------------------------------

CommonPlugin.ACTFM.Database.UnlockDatabase()

Hope this helps 

-- Jim Durkin

[blunt]

Thanks Jim, much appreciated