Thread: Pga3 Query Builder

Pga3 Query Builder

From
"Dave Page"
Date:
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.

Re: Pga3 Query Builder

From
Andreas Pflug
Date:
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



Re: Pga3 Query Builder

From
"Dave Page"
Date:

> -----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.

Re: Pga3 Query Builder

From
blacknoz@club-internet.fr
Date:
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
>


Re: Pga3 Query Builder

From
"Dave Page"
Date:
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
> >
>
>