Benicio:

1) you should not use DNN solution, UDT has its own solution, this increases developement speed and allows separate developement
4) after you compiled, you should be able to test the changes on your developement machine.
5) to create the zip I use a batch job, that first zips all files in resources.zip (have a look into the current UDT installtion package) and afterwards zips this with the other files into install.zip that can be used to install your version.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

I have not been able to get an additional procedure added to the database to fetch a list of UDT Modules and their respective data to populate the combos for my datatype.

I Updated DataProvider, SQLDataProvider, UserDefinedTableController, and EditMyType to get the info all the way up to the business layer, but upon installation of the module I get an SQL Error.

I would appreciate some further guidance.

I added the following lines at the end of 03.02.00.SqlDataProvider to get a list of the titles of the currently active UDT Modules:

CREATE PROCEDURE {databaseOwner}{objectQualifier}UserDefinedTable_GetTableModules()
AS
SELECT M.ModuleTitle
FROM {objectQualifier}Modules as M
INNER JOIN {objectQualifier}ModuleDefinitions as MD ON M.ModuleDefID = MD.ModuleDefID
WHERE     (MD.FriendlyName = 'User Defined Table') AND (M.IsDeleted = 0)
ORDER by M.ModuleTitle
GO


I get the following error when installing the module:
[L]SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 2: Incorrect syntax near ')'. Line 7: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\websites\UDTDev\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148 at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\websites\UDTDev\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282 CREATE PROCEDURE dbo.dnn_UserDefinedTable_GetTableModules() AS SELECT M.ModuleTitle FROM dnn_Modules as M INNER JOIN dnn_ModuleDefinitions as MD ON M.ModuleDefID = MD.ModuleDefID GO


Thanks again,
Benicio

It seems that you did not update your rescx files (App_LocalResources/SharedResources.resx etc).