void CuDlgPropertyPageSqlExpressionInParams::OnButton3Param()
{
CxDlgPropertySheetSqlExpressionWizard* pParent = (CxDlgPropertySheetSqlExpressionWizard*)GetParent();
CxDlgPropertySheetSqlExpressionWizard wizdlg;
wizdlg.m_queryInfo = pParent->m_queryInfo;
wizdlg.m_nFamilyID = FF_DATABASEOBJECTS;
wizdlg.m_nAggType = pParent->m_nAggType;
wizdlg.m_nCompare = pParent->m_nCompare;
wizdlg.m_nIn_notIn = pParent->m_nIn_notIn;
wizdlg.m_nSub_List = pParent->m_nSub_List;
//
// Initialize Tables or Views:
POSITION pos = pParent->m_listObject.GetHeadPosition();
try
{
while (pos != NULL)
{
CaDBObject* pObject = pParent->m_listObject.GetNext (pos);
CaDBObject* pNewObject = new CaDBObject(*pObject);
pNewObject->SetObjectID(pObject->GetObjectID());
wizdlg.m_listObject.AddTail (pNewObject);
}
pos = pParent->m_listStrColumn.GetHeadPosition();
while (pos != NULL)
{
CString strItem = pParent->m_listStrColumn.GetNext(pos);
wizdlg.m_listStrColumn.AddTail (strItem);
}
}
catch (CMemoryException* e)
{
theApp.OutOfMemoryMessage();
e->Delete();
return;
}
catch(...)
{
// _T("Cannot initialize the SQL assistant.");
AfxMessageBox (IDS_MSG_SQL_ASSISTANT, MB_ICONEXCLAMATION|MB_OK);
return;
}
int nResult = wizdlg.DoModal();
if (nResult == IDCANCEL)
return;
CString strStatement;
wizdlg.GetStatement (strStatement);
if (strStatement.IsEmpty())
return;
m_cParam3.ReplaceSel (strStatement);
}
//
// Initialize the columns of Current Selected Object (Table or View):
void CuDlgPropertyPageSqlWizardInsert1::OnSelchangeComboTable()
{
CWaitCursor doWaitCursor;
CxDlgPropertySheetSqlWizard* pParent = (CxDlgPropertySheetSqlWizard*)GetParent();
int nSel = m_cComboTable.GetCurSel();
SQLW_CuCheckListBoxColumnsClean(&m_cCheckListBoxColumn);
if (nSel == CB_ERR)
return;
try
{
CString strAll;
if (m_strAll.IsEmpty())
{
if (m_strAll.LoadString (IDS_SELECTALL) == 0)
m_strAll = _T("<All Columns>");
}
CaDBObject* pTable = (CaDBObject*)m_cComboTable.GetItemData(nSel);
ASSERT(pTable);
if (!pTable)
return;
CaLLQueryInfo info(pParent->m_queryInfo);
if (pTable->GetObjectID() == OBT_TABLE)
info.SetObjectType(OBT_TABLECOLUMN);
else
info.SetObjectType(OBT_VIEWCOLUMN);
info.SetItem2(pTable->GetName(), pTable->GetOwner());
m_cCheckListBoxColumn.AddString (m_strAll);
SQLW_CuCheckListBoxFillColumns (&m_cCheckListBoxColumn, &info);
//
// Select the previous selected columns if Any:
//
}
catch (CMemoryException* e)
{
e->Delete();
theApp.OutOfMemoryMessage();
}
catch (CeSqlException e)
{
AfxMessageBox (e.GetReason(), MB_ICONEXCLAMATION|MB_OK);
}
catch (...)
{
// _T("Cannot query the columns of the selected table");
AfxMessageBox (IDS_MSG_FAIL_2_QUERY_COLUMN, MB_ICONEXCLAMATION|MB_OK);
}
EnableWizardButtons();
}
BOOL CuDlgPropertyPageSqlWizardUpdate3::OnInitDialog()
{
CWaitCursor doWaitCursor;
CxDlgPropertySheetSqlWizard* pParent = (CxDlgPropertySheetSqlWizard*)GetParent();
CPropertyPage::OnInitDialog();
m_cListCtrl.m_queryInfo = pParent->m_queryInfo;
int nSel = CB_ERR;
CComboBox& comboTable = pParent->m_PageUpdate1.m_cComboTable;
nSel = comboTable.GetCurSel();
if (nSel != CB_ERR)
{
CaDBObject* pObj = (CaDBObject*)comboTable.GetItemData (nSel);
m_cListCtrl.m_queryInfo.SetItem2 (pObj->GetName(), pObj->GetOwner());
m_cListCtrl.m_queryInfo.SetObjectType(pObj->GetObjectID());
}
VERIFY (m_cListCtrl.SubclassDlgItem (IDC_LIST1, this));
m_ImageList.Create(1, 20, TRUE, 1, 0);
m_cListCtrl.SetImageList (&m_ImageList, LVSIL_SMALL);
CString strItem;
LVCOLUMN lvcolumn;
LSCTRLHEADERPARAMS2 lsp[2] =
{
{IDS_HEADER_COLUMN, 100, LVCFMT_LEFT, FALSE},
{IDS_HEADER_VALUE, 300, LVCFMT_LEFT, FALSE}
};
memset (&lvcolumn, 0, sizeof (LV_COLUMN));
lvcolumn.mask = LVCF_FMT|LVCF_SUBITEM|LVCF_TEXT|LVCF_WIDTH;
for (int i=0; i<2; i++)
{
strItem.LoadString(lsp[i].m_nIDS);
lvcolumn.fmt = lsp[i].m_fmt;
lvcolumn.pszText = (LPTSTR)(LPCTSTR)strItem;
lvcolumn.iSubItem = i;
lvcolumn.cx = lsp[i].m_cxWidth;
m_cListCtrl.InsertColumn (i, &lvcolumn);
}
m_cListCtrl.Invalidate();
EnableButtons();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}