Logo SQLinForm

 

Re: Two apparent bugs in latest version

I have been using SQLInform for several years now (site license at work) and love it.

With the latest version (Engine Release 5.0.5, GUI 5.0.4) there are a couple of anomalies.

1) Save formatted SQL to file.
The SQL being saved is the unformatted SQL.

2) Extra Linefeed in Formatted SQL

When formatting SQL, an extra linefeed is being inserted.
This problem did not occur with the older 4.x version I was using.
I cannot find any option that may be controlling this.

Example SQL:

select username, count(*) sessions
from v$session
where username is not null
group by username
order by sessions desc, username


Sample of hex output of formatted SQL:

75 73 65 72 6E 61 6D 65 0A 0A 20 2C username.. ,

Two LF now instead of one.

Jared



Edited 1 time(s). Last edit at 06/13/2016 11:12PM by guidomarcel.
Re: Two apparent bugs in latest version
December 18, 2015 10:33PM
Hi Jared,
many thanks for your feedback.

for both points I found a solution. Will solve this tomorrow. Please send me a mail to info at sqlinform dot com and I will send you a link to the new version.

Regards
Guido
Re: Two apparent bugs in latest version
December 20, 2015 11:32PM
Hi Jared,
please try the new version 5.0.14
Release 5.0.14

Regards
Guido
Thank you for being so responsive!

1) saving formatted SQL to text files works as expected, and the formatting is correct.

2) copying formatted SQL to clipboard, I am still seeing incorrect spacing.

Now though it is not double linefeed, but double CR.

For this first line:
SELECT DISTINCT

Hex:
53454C4543542044495354494E43540D0D0A2020...

Jared
Re: Two apparent bugs in latest version
December 22, 2015 11:29AM
Hi Jared,
did you copy the SQL
* using the "Copy to Clipboard" button
* using ctrl+c
* using right mouse-click + context menu ?

Regards
Guido
Hi Guido,

Sorry for taking so long to reply.

I tried all, and here are the results:

* "Copy to Clipboard" button

Worked as expected - no extra lines

* ctrl+c

Worked as expected - no extra lines

* using right mouse-click + context menu ?

Extra lines appear when pasted into another file
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 14 plus 3?
Message: