private void Setup(ExtractionInformation extractionInformation) { ExtractionInformation = extractionInformation; if (isFirstTimeSetupCalled) { //if the catalogue item has same name as the extraction information (alias) if (ExtractionInformation.CatalogueItem.Name.Equals(ExtractionInformation.ToString())) { _namesMatchedWhenDialogWasLaunched = true; } _querySyntaxHelper = ExtractionInformation.GetQuerySyntaxHelper(); QueryEditor = new ScintillaTextEditorFactory().Create(new RDMPCombineableFactory(), SyntaxLanguage.SQL, _querySyntaxHelper); QueryEditor.TextChanged += QueryEditorOnTextChanged; var autoComplete = new AutoCompleteProviderWin(_querySyntaxHelper); autoComplete.Add(ExtractionInformation.CatalogueItem.Catalogue); autoComplete.RegisterForEvents(QueryEditor); isFirstTimeSetupCalled = false; } var colInfo = ExtractionInformation.ColumnInfo; //deal with empty values in database (shouldn't be any but could be) if (string.IsNullOrWhiteSpace(ExtractionInformation.SelectSQL) && colInfo != null) { ExtractionInformation.SelectSQL = colInfo.Name.Trim(); ExtractionInformation.SaveToDatabase(); } QueryEditor.Text = ExtractionInformation.SelectSQL + (!string.IsNullOrWhiteSpace(ExtractionInformation.Alias) ? _querySyntaxHelper.AliasPrefix + ExtractionInformation.Alias : ""); lblFromTable.Text = colInfo == null?"MISSING ColumnInfo":colInfo.TableInfo.Name; if (!pSql.Controls.Contains(QueryEditor)) { pSql.Controls.Add(QueryEditor); } }