Re: [pgadmin-hackers] Find Dialog in SQL box (Admin3)?

[Andreas Pflug]

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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])