Thread: Pga3 Query Builder
As some of you may have noticed, I've been tinkering with the Query Builder code over the last few days. Currently I've done the following: - Updated to use ctlSQLResult, and batch loading code as per the Query Tool. - Added messages and history text boxes. - Fixed explain. - Allow removal of joins. - Fix for proper use with schemas - Made menus and toolbar match Query Tool as appropriate. Current known problems are: - Double clicking columns opens the join dialogue. This appears to be because wxWindows detects the double click as a drag-drop, which then overrides the double click event. I'm not sure how to fix this - think it needs Andreas' talents to fix :-) - It is currently possible to try to set criteria for * columns. I've not tried it, but it will probably fail spectacularly! Anyway, I would appreciate any feedback... Cheers, Dave.
Dave Page wrote: >As some of you may have noticed, I've been tinkering with the Query >Builder code over the last few days. Currently I've done the following: > >- Updated to use ctlSQLResult, and batch loading code as per the Query >Tool. >- Added messages and history text boxes. >- Fixed explain. >- Allow removal of joins. >- Fix for proper use with schemas >- Made menus and toolbar match Query Tool as appropriate. > >Current known problems are: > >- Double clicking columns opens the join dialogue. This appears to be >because wxWindows detects the double click as a drag-drop, which then >overrides the double click event. I'm not sure how to fix this - think >it needs Andreas' talents to fix :-) > I had a look at it. D&D is implemented by hand using EVT_MOTION, which lacks control over mouse clicks (the control eats it, before we could handle it). I wonder why EVT_LIST_BEGIN_DRAG wasn't used for this. EVT_LISTBOX_DCLICK is used on myList, which is a wxListCtrl, not a wxListBox -> no go. Regards, Andreas
> -----Original Message----- > From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] > Sent: 05 October 2003 16:37 > To: Dave Page > Cc: pgadmin-hackers@postgresql.org > Subject: Re: [pgadmin-hackers] Pga3 Query Builder > > > >- Double clicking columns opens the join dialogue. This > appears to be > >because wxWindows detects the double click as a drag-drop, > which then > >overrides the double click event. I'm not sure how to fix > this - think > >it needs Andreas' talents to fix :-) > > > I had a look at it. D&D is implemented by hand using > EVT_MOTION, which > lacks control over mouse clicks (the control eats it, before we could > handle it). I wonder why EVT_LIST_BEGIN_DRAG wasn't used for this. > > EVT_LISTBOX_DCLICK is used on myList, which is a wxListCtrl, not a > wxListBox -> no go. Hmm, well spotted! I'll keep playing with it - thanks for looking. Regards, Dave.
Hi Dave, FYI, this night snapshots didn't build automatically (I had no time to look at it, but some files may be missing). ui/frmMain.cpp:70:35: images/querybuilder.xpm: No such file or directory regards, Raphaël ----Message d'origine---- >Sujet: Re: [pgadmin-hackers] Pga3 Query Builder >Date: Sun, 5 Oct 2003 21:39:24 +0100 >De: "Dave Page" <dpage@vale-housing.co.uk> >A: "Andreas Pflug" <pgadmin@pse-consulting.de> >Copie à: <pgadmin-hackers@postgresql.org> > > > >> -----Original Message----- >> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] >> Sent: 05 October 2003 16:37 >> To: Dave Page >> Cc: pgadmin-hackers@postgresql.org >> Subject: Re: [pgadmin-hackers] Pga3 Query Builder >> >> >> >- Double clicking columns opens the join dialogue. This >> appears to be >> >because wxWindows detects the double click as a drag-drop, >> which then >> >overrides the double click event. I'm not sure how to fix >> this - think >> >it needs Andreas' talents to fix :-) >> > >> I had a look at it. D&D is implemented by hand using >> EVT_MOTION, which >> lacks control over mouse clicks (the control eats it, before we could >> handle it). I wonder why EVT_LIST_BEGIN_DRAG wasn't used for this. >> >> EVT_LISTBOX_DCLICK is used on myList, which is a wxListCtrl, not a >> wxListBox -> no go. > >Hmm, well spotted! I'll keep playing with it - thanks for looking. > >Regards, Dave. > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
Sorry, my fault. I've updated the makefile to pick up any and all xpm files. Regards, Dave. > -----Original Message----- > From: blacknoz@club-internet.fr [mailto:blacknoz@club-internet.fr] > Sent: 06 October 2003 10:59 > To: Dave Page; pgadmin@pse-consulting.de > Cc: pgadmin-hackers@postgresql.org > Subject: Re: Re: [pgadmin-hackers] Pga3 Query Builder > > > > Hi Dave, > > FYI, this night snapshots didn't build automatically (I had > no time to look at it, but some files may be missing). > > ui/frmMain.cpp:70:35: images/querybuilder.xpm: No such file > or directory > > > regards, > Raphaël > > ----Message d'origine---- > >Sujet: Re: [pgadmin-hackers] Pga3 Query Builder > >Date: Sun, 5 Oct 2003 21:39:24 +0100 > >De: "Dave Page" <dpage@vale-housing.co.uk> > >A: "Andreas Pflug" <pgadmin@pse-consulting.de> > >Copie à: <pgadmin-hackers@postgresql.org> > > > > > > > >> -----Original Message----- > >> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] > >> Sent: 05 October 2003 16:37 > >> To: Dave Page > >> Cc: pgadmin-hackers@postgresql.org > >> Subject: Re: [pgadmin-hackers] Pga3 Query Builder > >> > >> > >> >- Double clicking columns opens the join dialogue. This > >> appears to be > >> >because wxWindows detects the double click as a drag-drop, > >> which then > >> >overrides the double click event. I'm not sure how to fix > >> this - think > >> >it needs Andreas' talents to fix :-) > >> > > >> I had a look at it. D&D is implemented by hand using > >> EVT_MOTION, which > >> lacks control over mouse clicks (the control eats it, > before we could > >> handle it). I wonder why EVT_LIST_BEGIN_DRAG wasn't used for this. > >> > >> EVT_LISTBOX_DCLICK is used on myList, which is a wxListCtrl, not a > >> wxListBox -> no go. > > > >Hmm, well spotted! I'll keep playing with it - thanks for looking. > > > >Regards, Dave. > > > >---------------------------(end of > >broadcast)--------------------------- > >TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > >