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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
/**************************************************
*
*
**************************************************
* This code was created by Peter Harvey @ CodeByDesign.
* Released under GPL 18.FEB.99
*
* Contributions from...
* -----------------------------------------------
* Peter Harvey - pharvey@codebydesign.com
**************************************************/
#ifndef classISQL_included
#define classISQL_included
#include <qwidget.h>
#include <qmenubar.h>
#if (QT_VERSION>=300)
#include <qcombobox.h>
#else
#include <qcombo.h>
#endif
#include <qslider.h>
#include <qtabbar.h>
#if (QT_VERSION>=300)
#else
#include <qmlined.h>
#endif
#include <qlabel.h>
#include <qfile.h>
#include <qfiledialog.h>
#include <qtextstream.h>
#include <qvaluelist.h>
#include <qmultilineedit.h>
#include <qlayout.h>
#include <qstring.h>
#if (QT_VERSION>=300)
#include <qmemarray.h>
#else
#include <qarray.h>
#endif
#include <sqlext.h>
#ifndef max
#define max( a, b ) (((a) > (b)) ? (a) : (b))
#endif
#ifndef min
#define min( a, b ) (((a) > (b)) ? (b) : (a))
#endif
class classISQL : public QWidget
{
Q_OBJECT
public:
classISQL( SQLHDBC hDbc, QString qsDataSource, QWidget* parent = 0, const char* name = 0 );
~classISQL() {}
enum View { Text=1, TextDelimited=2, HTMLSource=3 } ;
public slots:
void ExecSQL( View );
void NewSQL();
void OpenSQL();
void SaveSQL();
void SaveAsSQL();
protected slots:
void ChangeTextType( int nTab );
void gotoHistoryItem( int nValue );
protected:
QTabBar * pTabBar;
QSlider * pSliderRecentSQL;
QMultiLineEdit * txtSQL;
QMultiLineEdit * txtResults;
QListBox * listStatus;
SQLHDBC hDbc;
QString qsDataSource;
QString qsResultsFileName;
QString qsSQLFileName;
QValueList<QString> listSQL;
int nSQL;
private:
void getResultsHeader( SQLHSTMT hStmt, SWORD nColumns, QString &qsHorizSep, QArray<int> &colWidths );
int getResultsBody( SQLHSTMT hStmt, SWORD nColumns, const QString &qsHorizSep, const QArray<int> &colWidths );
void appendHistoryItem();
void addStatus( const QString &statusMsg ) ;
};
#endif
|
