Re: VisualSQRIBE 5.0 rant

[Chad Redman <chad.redman@YALE.EDU>]

Adam,

Version 4.3 was flaky enough that I avoid the thing entirely. You
complained about F5 being mapped to Search in the new release, but even
ALT-F3 is non-standard! Horizontal scrolling is flaky; if the cursor is on
a short line, you can't scroll past it to see another line that's longer.
Also, it seemed to lock files so that you couldn't open them in anything
else, which also caused problems when publishing to Reportmart. Another
problem was that there was no option to change your database connection
without exiting the whole program.

I ended up changing my file associations so that I could avoid using
VisualSqribe wherever possible. For sqr and ini files, double-clicking
brings them up in a text editor (my choice!), and if I right-click, I can
choose to run it--in sqrw.exe, not VisualSqribe. Double-clicking on an spf
file opens it in the SQR Viewer.

For testing sqr scripts, what I do is make a Windows shortcut, where the
shortcut is something like
"D:\Sqribe\SQR\ORA\BINW\sqrw.exe program.sqr name/pass@sid -flags @args.dat"
Then it's edit file->save->click on shortcut->click on output. If the run
is long, I can continue editing while it is still running. I can also
create multiple shortcuts for different login, flags, or parameters.

A funny thing I noticed after changing my file associations in the Registry
is that if you ever open VisualSqribe again, it will overwrite your
settings, so that spf and sqr files will open in VisualSqribe. What's up
with that?? The only way I want my Registry mucked with is by a Setup
program or by editing manually!

If anyone is interested, I'm including my registry keys for changing the
file associations. The icons will change, but I haven't figured out how to
get at VSqribe's default document icon. Instead, I use the icon for VSqribe
itself. You will need to change the directory names of course, and also the
location of your file editor. The one I use is Programmer's File Editor,
which can be found at: http://www.lancs.ac.uk/people/cpaap/pfe/

Chad
------------------------------------------------------------------
Chad Redman                                  chad.redman@yale.edu
ITS/Admin. Sys., Yale University                   (203) 432-8853


At Wed, 10 Nov 1999 12:43:30 -0500, "Dray, Adam" <Adam.Dray@PHH.COM> wrote:
>I just got upgraded to VisualSQRIBE 5.0 from 4.3 or whatever I was using
>before.  I'm not happy with it.
[...]
>Anyone else feel the same way?  Anyone have any clevernesses that they use
>to get around the first two problems I mentioned?
>
>Adam Dray
REGEDIT4

[HKEY_CLASSES_ROOT\.inc]
@="SQRIBE.Source"

[HKEY_CLASSES_ROOT\.spf]
@="SQRIBE.Viewer"

[HKEY_CLASSES_ROOT\.sqr]
@="SQRIBE.Source"

[HKEY_CLASSES_ROOT\SQRIBE.Source]
@="SQR Source Files"
"EditFlags"=hex:00,00,00,00

[HKEY_CLASSES_ROOT\SQRIBE.Source\DefaultIcon]
@="D:\\Sqribe\\VISUAL~1\\PROGRAM\\vsqribe.exe,0"

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell]
@="open"

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\open]
"EditFlags"=hex:01,00,00,00

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\open\command]
@="\"D:\\Program Files\\Prog. File Editor\\Pfe32.exe\" \"%1\""

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\Open_in_VSqribe]
"EditFlags"=hex:01,00,00,00
@="Open in VSqribe"

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\Open_in_VSqribe\command]
@="D:\\Sqribe\\VISUAL~1\\PROGRAM\\vsqribe.exe \"%1\""

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\Run_Program]
"EditFlags"=hex:01,00,00,00
@="Run Program"

[HKEY_CLASSES_ROOT\SQRIBE.Source\shell\Run_Program\command]
@="D:\\Sqribe\\SQR\\ORA\\BINW\\sqrw.exe \"%1\""

[HKEY_CLASSES_ROOT\SQRIBE.Viewer]
@="SQR Output Files"
"EditFlags"=hex:00,00,00,00

[HKEY_CLASSES_ROOT\SQRIBE.Viewer\DefaultIcon]
@="D:\\Sqribe\\VisualSQRIBE\\PROGRAM\\vsqribe.exe,0"

[HKEY_CLASSES_ROOT\SQRIBE.Viewer\shell]
@=""

[HKEY_CLASSES_ROOT\SQRIBE.Viewer\shell\open]
"EditFlags"=hex:01,00,00,00

[HKEY_CLASSES_ROOT\SQRIBE.Viewer\shell\open\command]
@="\"D:\\Sqribe\\SQRViewer\\BINW\\sqrwv.exe\" \"%1\""