Hi. Here is the syntax you want to use (under HOST, SQL). Keep in mind that this should be used ONLY for Dynamic Forms 2.3. Any other version of Dynamic Forms the stored procedures might be changed.
This SQL will change the SQL field and Email Message field for Dynamic Fields from 4000 characters to a text column which will allow for more characters. This will take up more database space but for some users who require their email templates to be large than 4000 characters it's a workable solution.
Note: This is also assuming your database does not use object qualifiers (i.e. dnn_table) etc...
Alter Table DynamicForms_Events
Alter Column DynamicEmailMessage text Null
GO
Alter Table DynamicForms_Events
Alter Column DynamicSQL text Null
GO
DROP PROCEDURE dbo.[DynamicForms_AddDynamicEvent]
GO
DROP PROCEDURE dbo.[DynamicForms_UpdateDynamicEvent]
GO
CREATE PROCEDURE dbo.[DynamicForms_AddDynamicEvent]
@DynamicEventID as uniqueidentifier,
@EventName as nvarchar(200),
@EventType as nvarchar(50),
@DynamicQuestionID as uniqueidentifier,
@DynamicResponse as nvarchar(500),
@DNNRole as integer,
@DynamicRedirection as varchar(500),
@DynamicSQL as text,
@DynamicEmailMessage as text,
@DynamicEmailFrom as nvarchar(200),
@DynamicEmailTo as nvarchar(200),
@DynamicEmailSubject as nvarchar(300),
@ModuleID as integer,
@PortalID as integer,
@InActive as integer,
@FireEventParameter as integer
AS
Insert Into DynamicForms_Events(DynamicEventID, EventName, EventType, DynamicQuestionID,
DynamicResponse, DNNRole, DynamicRedirection, DynamicSQL, DynamicEmailMessage, DynamicEmailFrom,
DynamicEmailTo, DynamicEmailSubject, ModuleID, PortalID, InActive, FireEventParameter)
Values(@DynamicEventID,
@EventName,
@EventType,
@DynamicQuestionID,
@DynamicResponse,
@DNNRole,
@DynamicRedirection,
@DynamicSQL,
@DynamicEmailMessage,
@DynamicEmailFrom,
@DynamicEmailTo,
@DynamicEmailSubject,
@ModuleID,
@PortalID,
@InActive,
@FireEventParameter)
GO
CREATE PROCEDURE dbo.[DynamicForms_UpdateDynamicEvent]
@DynamicEventID as uniqueidentifier,
@EventName as nvarchar(200),
@EventType as nvarchar(50),
@DynamicQuestionID as uniqueidentifier,
@DynamicResponse as nvarchar(500),
@DNNRole as integer,
@DynamicRedirection as varchar(500),
@DynamicSQL as text,
@DynamicEmailMessage as text,
@DynamicEmailFrom as nvarchar(200),
@DynamicEmailTo as nvarchar(200),
@DynamicEmailSubject as nvarchar(300),
@ModuleID as integer,
@PortalID as integer,
@InActive as integer,
@FireEventParameter as Integer
AS
Update DynamicForms_Events
Set EventName = @EventName,
EventType = @EventType,
DynamicQuestionID = @DynamicQuestionID,
DynamicResponse = @DynamicResponse,
DNNRole = @DNNRole,
DynamicRedirection = @DynamicRedirection,
DynamicSQL = @DynamicSQL,
DynamicEmailMessage = @DynamicEmailMessage,
DynamicEmailFrom = @DynamicEmailFrom,
DynamicEmailTo = @DynamicEmailTo,
DynamicEmailSubject = @DynamicEmailSubject,
ModuleID = @ModuleID,
PortalID = @PortalID,
InActive = @InActive,
FireEventParameter = @FireEventParameter
Where DynamicEventID = @DynamicEventID
GO
|