1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_dbaccess.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski #ifndef _DBACCESS_UI_DIRECTSQL_HXX_
28*b1cdbd2cSJim Jagielski #include "directsql.hxx"
29*b1cdbd2cSJim Jagielski #endif
30*b1cdbd2cSJim Jagielski #ifndef _DBACCESS_UI_DIRECTSQL_HRC_
31*b1cdbd2cSJim Jagielski #include "directsql.hrc"
32*b1cdbd2cSJim Jagielski #endif
33*b1cdbd2cSJim Jagielski #ifndef _DBU_DLG_HRC_
34*b1cdbd2cSJim Jagielski #include "dbu_dlg.hrc"
35*b1cdbd2cSJim Jagielski #endif
36*b1cdbd2cSJim Jagielski #ifndef _SV_MSGBOX_HXX
37*b1cdbd2cSJim Jagielski #include <vcl/msgbox.hxx>
38*b1cdbd2cSJim Jagielski #endif
39*b1cdbd2cSJim Jagielski #ifndef _COMPHELPER_TYPES_HXX_
40*b1cdbd2cSJim Jagielski #include <comphelper/types.hxx>
41*b1cdbd2cSJim Jagielski #endif
42*b1cdbd2cSJim Jagielski #ifndef _SV_MSGBOX_HXX
43*b1cdbd2cSJim Jagielski #include <vcl/msgbox.hxx>
44*b1cdbd2cSJim Jagielski #endif
45*b1cdbd2cSJim Jagielski #ifndef _SV_SVAPP_HXX
46*b1cdbd2cSJim Jagielski #include <vcl/svapp.hxx>
47*b1cdbd2cSJim Jagielski #endif
48*b1cdbd2cSJim Jagielski #ifndef _VOS_MUTEX_HXX_
49*b1cdbd2cSJim Jagielski #include <vos/mutex.hxx>
50*b1cdbd2cSJim Jagielski #endif
51*b1cdbd2cSJim Jagielski #ifndef TOOLS_DIAGNOSE_EX_H
52*b1cdbd2cSJim Jagielski #include <tools/diagnose_ex.h>
53*b1cdbd2cSJim Jagielski #endif
54*b1cdbd2cSJim Jagielski
55*b1cdbd2cSJim Jagielski //........................................................................
56*b1cdbd2cSJim Jagielski namespace dbaui
57*b1cdbd2cSJim Jagielski {
58*b1cdbd2cSJim Jagielski //........................................................................
59*b1cdbd2cSJim Jagielski
60*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
61*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
62*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
63*b1cdbd2cSJim Jagielski
64*b1cdbd2cSJim Jagielski //====================================================================
65*b1cdbd2cSJim Jagielski //= LargeEntryListBox
66*b1cdbd2cSJim Jagielski //====================================================================
67*b1cdbd2cSJim Jagielski class LargeEntryListBox : public ListBox
68*b1cdbd2cSJim Jagielski {
69*b1cdbd2cSJim Jagielski public:
70*b1cdbd2cSJim Jagielski LargeEntryListBox( Window* _pParent, const ResId& _rId );
71*b1cdbd2cSJim Jagielski
72*b1cdbd2cSJim Jagielski protected:
73*b1cdbd2cSJim Jagielski virtual void UserDraw( const UserDrawEvent& rUDEvt );
74*b1cdbd2cSJim Jagielski };
75*b1cdbd2cSJim Jagielski
76*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
LargeEntryListBox(Window * _pParent,const ResId & _rId)77*b1cdbd2cSJim Jagielski LargeEntryListBox::LargeEntryListBox( Window* _pParent, const ResId& _rId )
78*b1cdbd2cSJim Jagielski :ListBox(_pParent, _rId )
79*b1cdbd2cSJim Jagielski {
80*b1cdbd2cSJim Jagielski EnableUserDraw(sal_True);
81*b1cdbd2cSJim Jagielski }
82*b1cdbd2cSJim Jagielski
83*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
UserDraw(const UserDrawEvent & _rUDEvt)84*b1cdbd2cSJim Jagielski void LargeEntryListBox::UserDraw( const UserDrawEvent& _rUDEvt )
85*b1cdbd2cSJim Jagielski {
86*b1cdbd2cSJim Jagielski if (LISTBOX_ENTRY_NOTFOUND == _rUDEvt.GetItemId())
87*b1cdbd2cSJim Jagielski ListBox::UserDraw( _rUDEvt );
88*b1cdbd2cSJim Jagielski else
89*b1cdbd2cSJim Jagielski _rUDEvt.GetDevice()->DrawText( _rUDEvt.GetRect(), GetEntry( _rUDEvt.GetItemId() ), TEXT_DRAW_LEFT | TEXT_DRAW_VCENTER | TEXT_DRAW_ENDELLIPSIS);
90*b1cdbd2cSJim Jagielski }
91*b1cdbd2cSJim Jagielski
92*b1cdbd2cSJim Jagielski //====================================================================
93*b1cdbd2cSJim Jagielski //= DirectSQLDialog
94*b1cdbd2cSJim Jagielski //====================================================================
DBG_NAME(DirectSQLDialog)95*b1cdbd2cSJim Jagielski DBG_NAME(DirectSQLDialog)
96*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
97*b1cdbd2cSJim Jagielski DirectSQLDialog::DirectSQLDialog( Window* _pParent, const Reference< XConnection >& _rxConn )
98*b1cdbd2cSJim Jagielski :ModalDialog(_pParent, ModuleRes(DLG_DIRECTSQL))
99*b1cdbd2cSJim Jagielski ,m_aFrame (this, ModuleRes(FL_SQL))
100*b1cdbd2cSJim Jagielski ,m_aSQLLabel (this, ModuleRes(FT_SQL))
101*b1cdbd2cSJim Jagielski ,m_aSQL (this, ModuleRes(ME_SQL))
102*b1cdbd2cSJim Jagielski ,m_aExecute (this, ModuleRes(PB_EXECUTE))
103*b1cdbd2cSJim Jagielski ,m_aHistoryLabel (this, ModuleRes(FT_HISTORY))
104*b1cdbd2cSJim Jagielski ,m_pSQLHistory(new LargeEntryListBox(this, ModuleRes(LB_HISTORY)))
105*b1cdbd2cSJim Jagielski ,m_aStatusFrame (this, ModuleRes(FL_STATUS))
106*b1cdbd2cSJim Jagielski ,m_aStatus (this, ModuleRes(ME_STATUS))
107*b1cdbd2cSJim Jagielski ,m_aButtonSeparator (this, ModuleRes(FL_BUTTONS))
108*b1cdbd2cSJim Jagielski ,m_aHelp (this, ModuleRes(PB_HELP))
109*b1cdbd2cSJim Jagielski ,m_aClose (this, ModuleRes(PB_CLOSE))
110*b1cdbd2cSJim Jagielski ,m_nHistoryLimit(20)
111*b1cdbd2cSJim Jagielski ,m_nStatusCount(1)
112*b1cdbd2cSJim Jagielski ,m_xConnection(_rxConn)
113*b1cdbd2cSJim Jagielski {
114*b1cdbd2cSJim Jagielski DBG_CTOR(DirectSQLDialog,NULL);
115*b1cdbd2cSJim Jagielski
116*b1cdbd2cSJim Jagielski FreeResource();
117*b1cdbd2cSJim Jagielski
118*b1cdbd2cSJim Jagielski m_aSQL.GrabFocus();
119*b1cdbd2cSJim Jagielski
120*b1cdbd2cSJim Jagielski m_aExecute.SetClickHdl(LINK(this, DirectSQLDialog, OnExecute));
121*b1cdbd2cSJim Jagielski m_aClose.SetClickHdl(LINK(this, DirectSQLDialog, OnClose));
122*b1cdbd2cSJim Jagielski m_pSQLHistory->SetSelectHdl(LINK(this, DirectSQLDialog, OnListEntrySelected));
123*b1cdbd2cSJim Jagielski m_pSQLHistory->SetDropDownLineCount(10);
124*b1cdbd2cSJim Jagielski
125*b1cdbd2cSJim Jagielski // add a dispose listener to the connection
126*b1cdbd2cSJim Jagielski Reference< XComponent > xConnComp(m_xConnection, UNO_QUERY);
127*b1cdbd2cSJim Jagielski OSL_ENSURE(xConnComp.is(), "DirectSQLDialog::DirectSQLDialog: invalid connection!");
128*b1cdbd2cSJim Jagielski if (xConnComp.is())
129*b1cdbd2cSJim Jagielski startComponentListening(xConnComp);
130*b1cdbd2cSJim Jagielski
131*b1cdbd2cSJim Jagielski m_aSQL.SetModifyHdl(LINK(this, DirectSQLDialog, OnStatementModified));
132*b1cdbd2cSJim Jagielski OnStatementModified(&m_aSQL);
133*b1cdbd2cSJim Jagielski }
134*b1cdbd2cSJim Jagielski
135*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
~DirectSQLDialog()136*b1cdbd2cSJim Jagielski DirectSQLDialog::~DirectSQLDialog()
137*b1cdbd2cSJim Jagielski {
138*b1cdbd2cSJim Jagielski {
139*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard(m_aMutex);
140*b1cdbd2cSJim Jagielski stopAllComponentListening();
141*b1cdbd2cSJim Jagielski }
142*b1cdbd2cSJim Jagielski delete m_pSQLHistory;
143*b1cdbd2cSJim Jagielski
144*b1cdbd2cSJim Jagielski DBG_DTOR(DirectSQLDialog,NULL);
145*b1cdbd2cSJim Jagielski }
146*b1cdbd2cSJim Jagielski
147*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
_disposing(const EventObject & _rSource)148*b1cdbd2cSJim Jagielski void DirectSQLDialog::_disposing( const EventObject& _rSource )
149*b1cdbd2cSJim Jagielski {
150*b1cdbd2cSJim Jagielski ::vos::OGuard aSolarGuard(Application::GetSolarMutex());
151*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard(m_aMutex);
152*b1cdbd2cSJim Jagielski
153*b1cdbd2cSJim Jagielski OSL_ENSURE(Reference< XConnection >(_rSource.Source, UNO_QUERY).get() == m_xConnection.get(),
154*b1cdbd2cSJim Jagielski "DirectSQLDialog::_disposing: where does this come from?");
155*b1cdbd2cSJim Jagielski (void)_rSource;
156*b1cdbd2cSJim Jagielski
157*b1cdbd2cSJim Jagielski {
158*b1cdbd2cSJim Jagielski String sMessage(ModuleRes(STR_DIRECTSQL_CONNECTIONLOST));
159*b1cdbd2cSJim Jagielski ErrorBox aError(this, WB_OK, sMessage);
160*b1cdbd2cSJim Jagielski aError.Execute();
161*b1cdbd2cSJim Jagielski }
162*b1cdbd2cSJim Jagielski
163*b1cdbd2cSJim Jagielski PostUserEvent(LINK(this, DirectSQLDialog, OnClose));
164*b1cdbd2cSJim Jagielski }
165*b1cdbd2cSJim Jagielski
166*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
getHistorySize() const167*b1cdbd2cSJim Jagielski sal_Int32 DirectSQLDialog::getHistorySize() const
168*b1cdbd2cSJim Jagielski {
169*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::getHistorySize");
170*b1cdbd2cSJim Jagielski return m_aStatementHistory.size();
171*b1cdbd2cSJim Jagielski }
172*b1cdbd2cSJim Jagielski
173*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
implEnsureHistoryLimit()174*b1cdbd2cSJim Jagielski void DirectSQLDialog::implEnsureHistoryLimit()
175*b1cdbd2cSJim Jagielski {
176*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::implEnsureHistoryLimit");
177*b1cdbd2cSJim Jagielski
178*b1cdbd2cSJim Jagielski if (getHistorySize() <= m_nHistoryLimit)
179*b1cdbd2cSJim Jagielski // nothing to do
180*b1cdbd2cSJim Jagielski return;
181*b1cdbd2cSJim Jagielski
182*b1cdbd2cSJim Jagielski sal_Int32 nRemoveEntries = getHistorySize() - m_nHistoryLimit;
183*b1cdbd2cSJim Jagielski while (nRemoveEntries--)
184*b1cdbd2cSJim Jagielski {
185*b1cdbd2cSJim Jagielski m_aStatementHistory.pop_front();
186*b1cdbd2cSJim Jagielski m_aNormalizedHistory.pop_front();
187*b1cdbd2cSJim Jagielski m_pSQLHistory->RemoveEntry((sal_uInt16)0);
188*b1cdbd2cSJim Jagielski }
189*b1cdbd2cSJim Jagielski }
190*b1cdbd2cSJim Jagielski
191*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
implAddToStatementHistory(const String & _rStatement)192*b1cdbd2cSJim Jagielski void DirectSQLDialog::implAddToStatementHistory(const String& _rStatement)
193*b1cdbd2cSJim Jagielski {
194*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::implAddToStatementHistory");
195*b1cdbd2cSJim Jagielski
196*b1cdbd2cSJim Jagielski // add the statement to the history
197*b1cdbd2cSJim Jagielski m_aStatementHistory.push_back(_rStatement);
198*b1cdbd2cSJim Jagielski
199*b1cdbd2cSJim Jagielski // normalize the statement, and remember the normalized form, too
200*b1cdbd2cSJim Jagielski String sNormalized(_rStatement);
201*b1cdbd2cSJim Jagielski sNormalized.SearchAndReplaceAll((sal_Unicode)'\n', ' ');
202*b1cdbd2cSJim Jagielski m_aNormalizedHistory.push_back(sNormalized);
203*b1cdbd2cSJim Jagielski
204*b1cdbd2cSJim Jagielski // add the normalized version to the list box
205*b1cdbd2cSJim Jagielski m_pSQLHistory->InsertEntry(sNormalized);
206*b1cdbd2cSJim Jagielski
207*b1cdbd2cSJim Jagielski // ensure that we don't exceed the history limit
208*b1cdbd2cSJim Jagielski implEnsureHistoryLimit();
209*b1cdbd2cSJim Jagielski }
210*b1cdbd2cSJim Jagielski
211*b1cdbd2cSJim Jagielski #ifdef DBG_UTIL
212*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
impl_CheckInvariants() const213*b1cdbd2cSJim Jagielski const sal_Char* DirectSQLDialog::impl_CheckInvariants() const
214*b1cdbd2cSJim Jagielski {
215*b1cdbd2cSJim Jagielski if (m_aStatementHistory.size() != m_aNormalizedHistory.size())
216*b1cdbd2cSJim Jagielski return "statement history is inconsistent!";
217*b1cdbd2cSJim Jagielski
218*b1cdbd2cSJim Jagielski if (!m_pSQLHistory)
219*b1cdbd2cSJim Jagielski return "invalid listbox!";
220*b1cdbd2cSJim Jagielski
221*b1cdbd2cSJim Jagielski if (m_aStatementHistory.size() != m_pSQLHistory->GetEntryCount())
222*b1cdbd2cSJim Jagielski return "invalid listbox entry count!";
223*b1cdbd2cSJim Jagielski
224*b1cdbd2cSJim Jagielski if (!m_xConnection.is())
225*b1cdbd2cSJim Jagielski return "have no connection!";
226*b1cdbd2cSJim Jagielski
227*b1cdbd2cSJim Jagielski return NULL;
228*b1cdbd2cSJim Jagielski }
229*b1cdbd2cSJim Jagielski #endif
230*b1cdbd2cSJim Jagielski
231*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
implExecuteStatement(const String & _rStatement)232*b1cdbd2cSJim Jagielski void DirectSQLDialog::implExecuteStatement(const String& _rStatement)
233*b1cdbd2cSJim Jagielski {
234*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::implExecuteStatement");
235*b1cdbd2cSJim Jagielski
236*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard(m_aMutex);
237*b1cdbd2cSJim Jagielski
238*b1cdbd2cSJim Jagielski String sStatus;
239*b1cdbd2cSJim Jagielski try
240*b1cdbd2cSJim Jagielski {
241*b1cdbd2cSJim Jagielski // create a statement
242*b1cdbd2cSJim Jagielski Reference< XStatement > xStatement = m_xConnection->createStatement();
243*b1cdbd2cSJim Jagielski OSL_ENSURE(xStatement.is(), "DirectSQLDialog::implExecuteStatement: no statement returned by the connection!");
244*b1cdbd2cSJim Jagielski
245*b1cdbd2cSJim Jagielski // execute it
246*b1cdbd2cSJim Jagielski if (xStatement.is())
247*b1cdbd2cSJim Jagielski xStatement->execute(_rStatement);
248*b1cdbd2cSJim Jagielski
249*b1cdbd2cSJim Jagielski // successfull
250*b1cdbd2cSJim Jagielski sStatus = String(ModuleRes(STR_COMMAND_EXECUTED_SUCCESSFULLY));
251*b1cdbd2cSJim Jagielski
252*b1cdbd2cSJim Jagielski // dispose the statement
253*b1cdbd2cSJim Jagielski ::comphelper::disposeComponent(xStatement);
254*b1cdbd2cSJim Jagielski }
255*b1cdbd2cSJim Jagielski catch(const SQLException& e)
256*b1cdbd2cSJim Jagielski {
257*b1cdbd2cSJim Jagielski sStatus = e.Message;
258*b1cdbd2cSJim Jagielski }
259*b1cdbd2cSJim Jagielski catch( const Exception& )
260*b1cdbd2cSJim Jagielski {
261*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
262*b1cdbd2cSJim Jagielski }
263*b1cdbd2cSJim Jagielski
264*b1cdbd2cSJim Jagielski // add the status text
265*b1cdbd2cSJim Jagielski addStatusText(sStatus);
266*b1cdbd2cSJim Jagielski }
267*b1cdbd2cSJim Jagielski
268*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
addStatusText(const String & _rMessage)269*b1cdbd2cSJim Jagielski void DirectSQLDialog::addStatusText(const String& _rMessage)
270*b1cdbd2cSJim Jagielski {
271*b1cdbd2cSJim Jagielski String sAppendMessage = String::CreateFromInt32(m_nStatusCount++);
272*b1cdbd2cSJim Jagielski sAppendMessage += String::CreateFromAscii(": ");
273*b1cdbd2cSJim Jagielski sAppendMessage += _rMessage;
274*b1cdbd2cSJim Jagielski sAppendMessage += String::CreateFromAscii("\n\n");
275*b1cdbd2cSJim Jagielski
276*b1cdbd2cSJim Jagielski String sCompleteMessage = m_aStatus.GetText();
277*b1cdbd2cSJim Jagielski sCompleteMessage += sAppendMessage;
278*b1cdbd2cSJim Jagielski m_aStatus.SetText(sCompleteMessage);
279*b1cdbd2cSJim Jagielski
280*b1cdbd2cSJim Jagielski m_aStatus.SetSelection(Selection(sCompleteMessage.Len(), sCompleteMessage.Len()));
281*b1cdbd2cSJim Jagielski }
282*b1cdbd2cSJim Jagielski
283*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
executeCurrent()284*b1cdbd2cSJim Jagielski void DirectSQLDialog::executeCurrent()
285*b1cdbd2cSJim Jagielski {
286*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::executeCurrent");
287*b1cdbd2cSJim Jagielski
288*b1cdbd2cSJim Jagielski String sStatement = m_aSQL.GetText();
289*b1cdbd2cSJim Jagielski
290*b1cdbd2cSJim Jagielski // execute
291*b1cdbd2cSJim Jagielski implExecuteStatement(sStatement);
292*b1cdbd2cSJim Jagielski
293*b1cdbd2cSJim Jagielski // add the statement to the history
294*b1cdbd2cSJim Jagielski implAddToStatementHistory(sStatement);
295*b1cdbd2cSJim Jagielski
296*b1cdbd2cSJim Jagielski m_aSQL.SetSelection(Selection());
297*b1cdbd2cSJim Jagielski m_aSQL.GrabFocus();
298*b1cdbd2cSJim Jagielski }
299*b1cdbd2cSJim Jagielski
300*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
switchToHistory(sal_Int32 _nHistoryPos,sal_Bool _bUpdateListBox)301*b1cdbd2cSJim Jagielski void DirectSQLDialog::switchToHistory(sal_Int32 _nHistoryPos, sal_Bool _bUpdateListBox)
302*b1cdbd2cSJim Jagielski {
303*b1cdbd2cSJim Jagielski CHECK_INVARIANTS("DirectSQLDialog::switchToHistory");
304*b1cdbd2cSJim Jagielski
305*b1cdbd2cSJim Jagielski if ((_nHistoryPos >= 0) && (_nHistoryPos < getHistorySize()))
306*b1cdbd2cSJim Jagielski {
307*b1cdbd2cSJim Jagielski // set the text in the statement editor
308*b1cdbd2cSJim Jagielski String sStatement = m_aStatementHistory[_nHistoryPos];
309*b1cdbd2cSJim Jagielski m_aSQL.SetText(sStatement);
310*b1cdbd2cSJim Jagielski OnStatementModified(&m_aSQL);
311*b1cdbd2cSJim Jagielski
312*b1cdbd2cSJim Jagielski if (_bUpdateListBox)
313*b1cdbd2cSJim Jagielski {
314*b1cdbd2cSJim Jagielski // selecte the normalized statement in the list box
315*b1cdbd2cSJim Jagielski m_pSQLHistory->SelectEntryPos((sal_uInt16)_nHistoryPos);
316*b1cdbd2cSJim Jagielski OSL_ENSURE(m_pSQLHistory->GetSelectEntry() == m_aNormalizedHistory[_nHistoryPos],
317*b1cdbd2cSJim Jagielski "DirectSQLDialog::switchToHistory: inconsistent listbox entries!");
318*b1cdbd2cSJim Jagielski }
319*b1cdbd2cSJim Jagielski
320*b1cdbd2cSJim Jagielski m_aSQL.GrabFocus();
321*b1cdbd2cSJim Jagielski m_aSQL.SetSelection(Selection(sStatement.Len(), sStatement.Len()));
322*b1cdbd2cSJim Jagielski }
323*b1cdbd2cSJim Jagielski else
324*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "DirectSQLDialog::switchToHistory: invalid position!");
325*b1cdbd2cSJim Jagielski }
326*b1cdbd2cSJim Jagielski
327*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
328*b1cdbd2cSJim Jagielski IMPL_LINK( DirectSQLDialog, OnStatementModified, void*, /*NOTINTERESTEDIN*/ )
329*b1cdbd2cSJim Jagielski {
330*b1cdbd2cSJim Jagielski m_aExecute.Enable(0 != m_aSQL.GetText().Len());
331*b1cdbd2cSJim Jagielski return 0L;
332*b1cdbd2cSJim Jagielski }
333*b1cdbd2cSJim Jagielski
334*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
335*b1cdbd2cSJim Jagielski IMPL_LINK( DirectSQLDialog, OnClose, void*, /*NOTINTERESTEDIN*/ )
336*b1cdbd2cSJim Jagielski {
337*b1cdbd2cSJim Jagielski EndDialog( RET_OK );
338*b1cdbd2cSJim Jagielski return 0L;
339*b1cdbd2cSJim Jagielski }
340*b1cdbd2cSJim Jagielski
341*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
342*b1cdbd2cSJim Jagielski IMPL_LINK( DirectSQLDialog, OnExecute, void*, /*NOTINTERESTEDIN*/ )
343*b1cdbd2cSJim Jagielski {
344*b1cdbd2cSJim Jagielski executeCurrent();
345*b1cdbd2cSJim Jagielski return 0L;
346*b1cdbd2cSJim Jagielski }
347*b1cdbd2cSJim Jagielski
348*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
349*b1cdbd2cSJim Jagielski IMPL_LINK( DirectSQLDialog, OnListEntrySelected, void*, /*NOTINTERESTEDIN*/ )
350*b1cdbd2cSJim Jagielski {
351*b1cdbd2cSJim Jagielski if (!m_pSQLHistory->IsTravelSelect())
352*b1cdbd2cSJim Jagielski {
353*b1cdbd2cSJim Jagielski const sal_uInt16 nSelected = m_pSQLHistory->GetSelectEntryPos();
354*b1cdbd2cSJim Jagielski if (LISTBOX_ENTRY_NOTFOUND != nSelected)
355*b1cdbd2cSJim Jagielski switchToHistory(nSelected, sal_False);
356*b1cdbd2cSJim Jagielski }
357*b1cdbd2cSJim Jagielski return 0L;
358*b1cdbd2cSJim Jagielski }
359*b1cdbd2cSJim Jagielski
360*b1cdbd2cSJim Jagielski //........................................................................
361*b1cdbd2cSJim Jagielski } // namespace dbaui
362*b1cdbd2cSJim Jagielski //........................................................................
363*b1cdbd2cSJim Jagielski
364