It would be nice if you could highlight the results and copy them from/to the clipboard with the mouse ... (right click/copy context menus)

did you already try the format clipboard feature ? Short-cut is ctrl+K

Well I had not...so I did ... this requires that I highlight my text in the editor....then right-click-copy (or cntrl-C) ... then click on the window for SQLINFORM, then use the ;keyboard to do CONTROL-K, then click back on my editor and then right-click / paste (or control V )...

What I'm talking about would be to be able to do it all with the mouse....

Is it not possible to cut/paste with the mouse within SQLINFORM?

Hi c141heaven,
thanks for your feedback.

I am currently adding new stuff to the new version. I could also add the mouse cut/paste.

Are you working with the desktop version including the system tray feature? If this is the case you can easily format your SQL with a right mouse-click in the system tray. this is the fastest way to format your SQL

If you are not able to work with the system tray you could as a work-aroung:
1. highlight text in the editor....then right-click-copy (or cntrl-C) ...
2. then click on the window for SQLINFORM, click on menu "Actions" and then click on "Format Clipboard"
3. click back on editor and then right-click / paste (or control V )...

I hope I understood your issue correctly. If not, please be patient with me

Regards
Guido

I am using the desktop version .... and the system tray (format clipboard option works pretty well ......)

I still have a few suggestions with the actual formatting...which is a different topic entirely....

For example:

If I paste in this (with SQL Server selected as the input type)

CREATE PROCEDURE dbo.QS_TRAN_CODE_IS_VALID @TC VARCHAR(30)
AS
SET NOCOUNT ON ;
SELECT TRAN_CODE AS TC FROM TRANCODES WHERE TRAN_CODE = @TC

IF @@ROWCOUNT = 0 SELECT 'NOT FOUND' AS TC

GO

I get this as an output result:

CREATE PROCEDURE dbo.QS_TRAN_CODE_IS_VALID @TC VARCHAR(30)
AS
SET NOCOUNT ON ;
SELECT TRAN_CODE AS TC
FROM TRANCODES
WHERE TRAN_CODE = @TC
IF @@ROWCOUNT = 0
SELECT 'NOT FOUND' AS TC
GO

My suggestion is that it be formatted more along these lines:

CREATE PROCEDURE dbo.QS_TRAN_CODE_IS_VALID
@TC VARCHAR(30)
AS
SET NOCOUNT ON ;

SELECT TRAN_CODE AS TC
FROM TRANCODES
WHERE TRAN_CODE = @TC

IF @@ROWCOUNT = 0
SELECT 'NOT FOUND' AS TC
GO

Which I find easier to read ...for these reasons:

1. The input parm to the stored proc are on a separate line from the name .... (when you format multiple parms it's
keeping the FIRST parm on the same line, then the subsequent ones on separate lines ....like I think they ALL should
be).

2. The GO is left justified...making it easier to see where the end of the procedure is in a large script containing many
procedures...

3. The IF statement has a leading blank line .... this makes it easier to see than all bunched together ....

I realize there are many options for how spacing and alignment is done ... but I've played around with nearly all of them
trying each one and each combination ... can't see to find the right set that gives me quite what I'd like to see. I know
it's hard to please everybody's particular preferences..... but keep up the good work. I use your program just about
constantly in my work and even with the little little things like I've mentioned above....it still saves me a lot of time
and makes my work easier.

Thanks.

Hi C141heaven,
I moved this suggestion to a seperate thread so that it will not get lost.
Thanks
Guido

Guido, this is related to the request I gave you a while ago. It would create a right-click context menu that includes the normal cut/copy/paste/select all you see on many editing programs. This enhancement alone would increase productivity tremendously by cutting out several more manual steps.

Thanks,

Jason

Hi Jason,
thanks for your message. I investigated about the right-click. It seems that a Java applet would need special authorisations to allow a new pop-up window. As I want to make the applet available for as many people as possible I would not like to add special authorisations.

In the desktop version there is the system tray feature. it works with the right-mouse click. Did you already try it?
Regards
Guido

Yes, I have tried it and I do use it, however, it's a little less user friendly. Simply cutting, copying or selcting all text should be something everyone could and would use. I'm not sure I understand the technical limitations behind it as I am not familiar with Java.

Thanks,

Jason

Hi Jason,
thanks for your message. Today I checked again (and tried many different things for hours) if it is possible to add the right-cmouse click context menu to the online version. The final answer is that Java does not allow this operation in an applet executed out of the web browser.

But it is of course possible in the desktop version. I will add it within the next weeks.
Regards
Guido

I did it. I have to admit that it is really nice working with a right-mouse click. I will make it available with the next Release (probably published during the weekend)
Regards
Guido



Edited 1 time(s). Last edit at 10/30/2009 02:09PM by guidomarcel.

it is now available in the November Release :-)