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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
/**************************************************
*
*
**************************************************
* 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
#ifdef QT_V4LAYOUT
#include <Qt/qwidget.h>
#include <Qt/qmenubar.h>
#include <Qt/q3combobox.h>
#include <Qt/qslider.h>
#include <Qt/qtabbar.h>
#include <Qt/qlabel.h>
#include <Qt/qfile.h>
#include <Qt/qfiledialog.h>
#include <Qt/qtextstream.h>
#include <Qt/q3valuelist.h>
#include <Qt/q3multilineedit.h>
#include <Qt/qlayout.h>
#include <Qt/qstring.h>
#include <Qt/q3memarray.h>
#else
#include <qwidget.h>
#include <qmenubar.h>
#include <qcombo.h>
#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>
#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;
#ifdef QT_V4LAYOUT
Q3MultiLineEdit * txtSQL;
Q3MultiLineEdit * txtResults;
Q3ListBox * listStatus;
Q3ValueList<QString> listSQL;
#else
QMultiLineEdit * txtSQL;
QMultiLineEdit * txtResults;
QListBox * listStatus;
QValueList<QString> listSQL;
#endif
SQLHDBC hDbc;
QString qsDataSource;
QString qsResultsFileName;
QString qsSQLFileName;
int nSQL;
private:
#ifdef QT_V4LAYOUT
void getResultsHeader( SQLHSTMT hStmt, SWORD nColumns, QString &qsHorizSep, Q3MemArray<int> &colWidths );
int getResultsBody( SQLHSTMT hStmt, SWORD nColumns, const QString &qsHorizSep, const Q3MemArray<int> &colWidths );
#else
void getResultsHeader( SQLHSTMT hStmt, SWORD nColumns, QString &qsHorizSep, QArray<int> &colWidths );
int getResultsBody( SQLHSTMT hStmt, SWORD nColumns, const QString &qsHorizSep, const QArray<int> &colWidths );
#endif
void appendHistoryItem();
void addStatus( const QString &statusMsg ) ;
};
#endif
|
