DECLARE @tsql VARCHAR(MAX) if not exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0116') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN SET @tsql = 'CREATE VIEW vw_Indoo_template_0116 AS SELECT TOP (100) PERCENT DesktopModules.DesktopModuleID, DesktopModules.FriendlyName, ModuleDefinitions.ModuleDefID, Modules.ModuleID, Modules.ModuleTitle, Modules.AllTabs, Modules.PortalID, Tabs.ParentId, Tabs.TabID, Tabs.TabName, Tabs.Title, Portals.PortalName FROM TabModules INNER JOIN Modules ON TabModules.ModuleID = Modules.ModuleID INNER JOIN Tabs ON TabModules.TabID = Tabs.TabID INNER JOIN ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID INNER JOIN DesktopModules ON ModuleDefinitions.DesktopModuleID = DesktopModules.DesktopModuleID INNER JOIN Portals ON Tabs.PortalID = Portals.PortalID ' END EXEC (@tsql) GO DECLARE @tsql VARCHAR(MAX) if not exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0116a') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN SET @tsql = 'CREATE VIEW vw_Indoo_template_0116a AS SELECT DISTINCT TOP 100 PERCENT FriendlyName FROM vw_Indoo_template_0116 ORDER BY FriendlyName ' END EXEC (@tsql) binaryData.fileSytemDBPath gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename vw_Indoo_template_0116 tableKeyColumn DesktopModuleID showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord gridViewColumn.0.columnName DesktopModuleID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridViewColumn.1.columnName FriendlyName gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.2.columnName ModuleDefID gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.3.columnName ModuleID gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.isOther 0 gridViewColumn.4.columnName ModuleTitle gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 0 gridViewColumn.5.columnName AllTabs gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 1 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.isOther 0 gridViewColumn.6.columnName PortalID gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridViewColumn.6.isOther 0 gridViewColumn.7.columnName ParentId gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridViewColumn.7.isOther 0 gridViewColumn.8.columnName TabID gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 1 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridViewColumn.8.isOther 0 gridViewColumn.9.columnName TabName gridViewColumn.9.Visible on gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridViewColumn.9.isOther 0 gridViewColumn.10.columnName Title gridViewColumn.10.Visible on gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridViewColumn.10.isOther 0 gridViewColumn.11.columnName PortalName gridViewColumn.11.Visible on gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridViewColumn.11.isOther 0 gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption gridViewColumn.4.caption gridViewColumn.5.caption gridViewColumn.6.caption gridViewColumn.7.caption gridViewColumn.8.caption gridViewColumn.9.caption Page (tabname) gridViewColumn.10.caption gridViewColumn.11.caption gridViewColumn.9.width gridViewColumn.9.defaultContent gridViewColumn.9.formatData gridViewColumn.9.importDefault gridViewColumn.9.filterAdditionalColumn gridViewColumn.9.defaultSortColumn gridViewColumn.9.isBoolean gridViewColumn.9.isLink on gridViewColumn.9.isBinary gridViewColumn.9.isJoin gridViewColumn.9.isHtmlAttributes gridViewColumn.9.navigateUrl gridViewColumn.9.navigateUrlParameterName tabid gridViewColumn.9.navigateUrlParameterColumn TabID gridViewColumn.9.navigateUrlTarget _blank gridViewColumn.9.urlAddCommand 0 gridViewColumn.9.navigateUrlIsButton gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.ddlType 1 gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable vw_Indoo_template_0116a gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName FriendlyName gridViewColumn.1.sourceTextColumnName FriendlyName gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlAllOption on binaryData.fileSytemDBPath |DataDirectory|indooGrid\ gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename vw_Indoo_template_0116 tableKeyColumn DesktopModuleID showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord gridViewColumn.0.columnName DesktopModuleID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridViewColumn.1.columnName FriendlyName gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.2.columnName ModuleDefID gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.3.columnName ModuleID gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.isOther 0 gridViewColumn.4.columnName ModuleTitle gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 0 gridViewColumn.5.columnName AllTabs gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 1 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.isOther 0 gridViewColumn.6.columnName PortalID gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridViewColumn.6.isOther 0 gridViewColumn.7.columnName ParentId gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridViewColumn.7.isOther 0 gridViewColumn.8.columnName TabID gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 1 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridViewColumn.8.isOther 0 gridViewColumn.9.columnName TabName gridViewColumn.9.Visible on gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridViewColumn.9.isOther 0 gridViewColumn.10.columnName Title gridViewColumn.10.Visible on gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridViewColumn.10.isOther 0 gridViewColumn.11.columnName PortalName gridViewColumn.11.Visible on gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridViewColumn.11.isOther 0 gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption gridViewColumn.4.caption gridViewColumn.5.caption gridViewColumn.6.caption gridViewColumn.7.caption gridViewColumn.8.caption gridViewColumn.9.caption Page (tabname) gridViewColumn.10.caption gridViewColumn.11.caption gridViewColumn.9.width gridViewColumn.9.defaultContent gridViewColumn.9.formatData gridViewColumn.9.importDefault gridViewColumn.9.filterAdditionalColumn gridViewColumn.9.defaultSortColumn gridViewColumn.9.isBoolean gridViewColumn.9.isLink on gridViewColumn.9.isBinary gridViewColumn.9.isJoin gridViewColumn.9.isHtmlAttributes gridViewColumn.9.navigateUrl gridViewColumn.9.navigateUrlParameterName tabid gridViewColumn.9.navigateUrlParameterColumn TabID gridViewColumn.9.navigateUrlTarget _blank gridViewColumn.9.urlAddCommand 0 gridViewColumn.9.navigateUrlIsButton gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.ddlType 1 gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable vw_Indoo_template_0116a gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName FriendlyName gridViewColumn.1.sourceTextColumnName FriendlyName gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlAllOption on