SQL Statement limited? - Data Springs Inc. - DotNetNuke Modules - DotNetNuke Module Product Forums - Product Discussion - DotNetNuke Modules

SQL Statement limited?

Last Post 09-01-2011 09:21 AM by Don Gee. 4 Replies.

Author

Messages

Sean Sean

going with the flow
Posts:54
Avatar

08-31-2011 04:09 AM
Hi there, In the Form Completion Events I use the dynamic SQL statement option to insert data of about 140 fields into a table. It appears that when updating the event not all the data in the statement is saved. Could it be that there is a limit on what can be written in this statement? Thanks!

Don Gee

river guide
Posts:273
Avatar

08-31-2011 08:56 AM
Hmm, Are all fields getting an insert on part of your records and then some of them aren't being inserted

Chad Nash

Posts:5260

08-31-2011 12:44 PM
At one point this was limited but I think there was an enhancement in the most recent builds to allow for NVARCHAR(MAX) within the fields. Can you tell me what specific version you are on. Depending on the version you might have to alter the column/table to allow for a larger size of the SQL and also the stored procedures that add/update the procedure. -Chad

Sean Sean

going with the flow
Posts:54
Avatar

Don Gee

river guide
Posts:273
Avatar

09-01-2011 09:21 AM
Hi Sean, Your version is several years old now for Dynamic Forms. In future versions the size was increased to allow what you are trying to do. You can download the trial version of the current version of Dynamic Forms and then test what you are doing and then things should be ok. Thanks