DECLARE @tsql VARCHAR(MAX) if not exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0115') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN SET @tsql = 'CREATE VIEW vw_Indoo_template_0115 AS SELECT TOP 100 PERCENT dbo.DesktopModules.DesktopModuleID, dbo.DesktopModules.FriendlyName, dbo.DesktopModules.Version, dbo.DesktopModules.IsPremium FROM dbo.Modules INNER JOIN dbo.TabModules ON dbo.Modules.ModuleID = dbo.TabModules.ModuleID INNER JOIN dbo.ModuleDefinitions ON dbo.Modules.ModuleDefID = dbo.ModuleDefinitions.ModuleDefID RIGHT OUTER JOIN dbo.DesktopModules ON dbo.ModuleDefinitions.DesktopModuleID = dbo.DesktopModules.DesktopModuleID WHERE (dbo.DesktopModules.IsAdmin = 0) GROUP BY dbo.DesktopModules.DesktopModuleID, dbo.DesktopModules.FriendlyName, dbo.DesktopModules.Version, dbo.DesktopModules.IsPremium HAVING (COUNT(dbo.TabModules.TabID) = 0)' END EXEC (@tsql) binaryData.fileSytemDBPath gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename vw_Indoo_template_0115 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 FriendlyName 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 Version gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.2.columnName IsPremium 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.0.caption gridViewColumn.1.caption gridViewColumn.2.caption notSkipSqlOnImport on binaryData.fileSytemDBPath |DataDirectory|indooGrid\ gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename vw_Indoo_template_0115 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 FriendlyName 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 Version gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.2.columnName IsPremium 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.0.caption gridViewColumn.1.caption gridViewColumn.2.caption notSkipSqlOnImport on