From: | Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> |
---|---|
To: | Yurgis Baykshtis <ybaykshtis(at)aurigin(dot)com>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Find Dialog in SQL box (Admin3)? |
Date: | 2003-06-01 23:12:30 |
Message-ID: | 3EDA885E.4050308@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi Yurgis,
I committed most of your work to cvs.
>Here is my contribution:
>
>1. Custom SQL lexer registered and implemented directly in ctlSQLBox
>class.
>
>
Since the custom lexer isn't unicode clean, it's still commented out.
Please fix it, using wxString::ToAscii and wxString::FromAscii.
wxScintilla seems to use a mixture of ansi and unicode, not very healthy...
>I've done this to detect AS '....' construction.
>Everything inside quotes after AS will be highlighted as in regular SQL
>code. Escaped quotes (\') are also detected correctly.
>Now, the more preferable way to edit/update stored procedures will be
>using Query window (instead of Properties dialog). So, just select a
>function, click SQL on toolbar and edit the code. Once your change is
>ready just click "Play" and the procedure will updated in the DB. Way
>more convenient, isn't it?
>
I'd be working the same way, because I like to have stored my work into
files. There's still one advantage of using the properties dialog: There
are less quotes. Please check if highlighting is there correct too.
>2. More keywords added such as UNIUON, INNER, OUTER, etc.
>
There will always be one missing... :-)
>3. Find Dialog. Press Ctrl-F in any SQL box to activate Find dialog.
>No regular expressions though, since wx UI does not support that in its
>Find dialog. Custom Find dialog needs to be implemented for that.
>
Do you miss regex?
>
>4. Edit Menu in Query window. I also added Edit menu to the Query
>window.
>
Oops, that line got lost. We now also have a toolbar button for find.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Yurgis Baykshtis | 2003-06-01 23:21:18 | Re: Find Dialog in SQL box (Admin3)? |
Previous Message | Dave Page | 2003-06-01 08:35:19 | Re: Find Dialog in SQL box (Admin3)? |