BOOL CxDlgObjectComment::FillListColumnWithComment( void )
{
//
// Get Session
int hdl, nRes = RES_ERR ;
TCHAR tcDBName [MAXOBJECTNAME];
TCHAR tcObjectName [MAXOBJECTNAME];
TCHAR tcObjectOwner [MAXOBJECTNAME];
CString strSess;
m_tcObjComment = NULL;
CString strVNodeName = (LPTSTR)GetVirtNodeName(m_nNodeHandle);
x_strcpy(tcDBName,m_csDBName);
x_strcpy(tcObjectName, m_csObjectName );
x_strcpy(tcObjectOwner,m_csObjectOwner);
strSess.Format (_T("%s::%s"),
(LPTSTR)(LPCTSTR)strVNodeName,
(LPTSTR)(LPCTSTR)m_csDBName);
nRes = Getsession ((LPUCHAR)(LPCTSTR)strSess, SESSION_TYPE_CACHEREADLOCK, &hdl);
if (nRes != RES_SUCCESS)
{
TRACE0 (_T("CxDlgObjectComment::FillListColumnWithComment(): Fail to Get the session\n"));
return FALSE;
}
nRes = SQLGetComment( (LPTSTR)(LPCTSTR)strVNodeName, tcDBName, tcObjectName, tcObjectOwner,
&m_tcObjComment, m_ListColumn);
ReleaseSession (hdl, RELEASE_COMMIT);
if (nRes != RES_SUCCESS)
{
CString csMsg;
csMsg.LoadString(IDS_E_COMMENTS_FAILED);
MessageWithHistoryButton(m_hWnd,csMsg);
return FALSE;
}
if (m_tcObjComment)
SetCommentObject(m_tcObjComment);
return TRUE;
}
int VDBAGetCommentInfo ( LPTSTR lpNodeName,LPTSTR lpDBName, LPTSTR lpObjName,
LPTSTR lpObjOwner,LPTSTR *lpObjComment, LPOBJECTLIST lpObjColumn)
{
int ires, hdl;
TCHAR tchszConnection [MAXOBJECTNAME*2];
wsprintf (tchszConnection,"%s::%s", lpNodeName, lpDBName);
ires = Getsession (tchszConnection, SESSION_TYPE_CACHENOREADLOCK, &hdl);
if (ires != RES_SUCCESS)
return RES_ERR;
ires = SQLGetComment( lpNodeName, lpDBName, lpObjName, lpObjOwner,
lpObjComment, lpObjColumn);
if (ires==RES_SUCCESS)
ires=ReleaseSession(hdl, RELEASE_COMMIT);
else
ReleaseSession(hdl, RELEASE_ROLLBACK);
return ires;
}
