1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
/**************************************************
*
*
**************************************************
* This code was created by Peter Harvey @ CodeByDesign.
* Released under GPL 18.FEB.99
*
* Contributions from...
* -----------------------------------------------
* Peter Harvey - pharvey@codebydesign.com
**************************************************/
#include "classIndexs.h"
#include "classODBC.h" // my_msgBox
#include <qpixmap.h>
#include "keysilver2.xpm"
classIndexs::classIndexs( QListViewItem *pParent, QListViewItem *pAfter, classCanvas *pCanvas, SQLHENV hDbc, const char *pszTable, const char *pszLibrary )
: classNode( pParent, pAfter, pCanvas ), hDbc( hDbc ), qsTable( pszTable ), qsLibrary( pszLibrary )
{
setText( 0, "Indexs" );
setText( 1, "" );
setText( 2, "" );
listIndexs.setAutoDelete( TRUE );
setPixmap( 0, QPixmap( keysilver2_xpm ) );
setExpandable( TRUE );
}
void classIndexs::setOpen( bool bOpen )
{
if ( bOpen ) // Always refresh
LoadIndexs();
else
listIndexs.clear() ;
QListViewItem::setOpen( bOpen );
}
void classIndexs::LoadIndexs()
{
CursorScoper s(listView()) ;
SQLRETURN nReturn ;
SQLCHAR szIndexName[MAX_COLUMN_WIDTH];
SQLCHAR szColumnName[MAX_COLUMN_WIDTH];
SQLCHAR szUnique[MAX_COLUMN_WIDTH];
int bUnique;
SQLLEN nIndicator;
QString qsDesc ;
classColumn *pColumn = NULL ;
// CREATE A STATEMENT
StatementScoper stmt( hDbc ) ; if ( !stmt() ) return ;
// EXECUTE OUR SQL/CALL
if ( !SQL_SUCCEEDED(nReturn=SQLStatistics( stmt(), 0, 0, (SQLCHAR*)qsLibrary.data(), SQL_NTS, (SQLCHAR*)qsTable.data(), SQL_NTS, 0, 0 ) ) )
return my_msgBox( "classIndexs", "SQLStatistics", nReturn, NULL, NULL, stmt() ) ;
// GET RESULTS
while ( SQL_SUCCEEDED( SQLFetch( stmt() ) ) )
{
nReturn = SQLGetData( stmt(), 9, SQL_C_CHAR, &szColumnName[0], sizeof(szColumnName), &nIndicator );
if ( !SQL_SUCCEEDED(nReturn) || nIndicator == SQL_NULL_DATA )
strcpy( (char *)szColumnName, "Unknown" );
nReturn = SQLGetData( stmt(), 4, SQL_C_LONG, &bUnique, sizeof(bUnique), &nIndicator );
if ( !SQL_SUCCEEDED(nReturn) || nIndicator == SQL_NULL_DATA || !bUnique )
strcpy( (char *)szUnique, "NON-UNIQUE" );
else
strcpy( (char *)szUnique, "UNIQUE" );
nReturn = SQLGetData( stmt(), 6, SQL_C_CHAR, &szIndexName[0], sizeof(szIndexName), &nIndicator );
if ( !SQL_SUCCEEDED(nReturn) || nIndicator == SQL_NULL_DATA )
strcpy( (char *)szIndexName, "Unknown" );
qsDesc.sprintf("Column=%s %s", QString((char*)szColumnName).stripWhiteSpace().data(), (char*)szUnique ) ;
listIndexs.append( pColumn = new classColumn( this, pColumn, pCanvas, hDbc, QString((char*)szIndexName).stripWhiteSpace(), "INDEX", qsDesc ) );
}
}
|
