SqlDbx Forum

jweyrich

Member

Problem: SqlDbx hangs on replace

I pasted a Java code that contains a sql statement, so I tried to replace the java code to keep only the SQL statement, but SqlDbx hangs on the 2nd replace.
First I replaced sql.append(" by nothing, then I tried to replace "); by nothing also, but SqlDbx hangs when I try it.

Here's the code I tried to apply the 2 replaces:

sql.append(" select  S.column1 , ");
        sql.append("            S.column2 , ");
        sql.append("            S.column3, ");
        sql.append("            S.column4, ");
        sql.append("            C.column1, ");
        sql.append("            I.column1 ");
        sql.append("    from    table1 S, ");
        sql.append("            table2 I, ");
        sql.append("            table3 C");
        sql.append("    where   I.column1 = " + id);
        sql.append("    and     S.column2 = I.column1 ");
        sql.append("    and     I.column2 = C.column1 ");
        sql.append("    order by UPPER(S.anotherColumn) ");

Can someone confirm?

sqldbxhelp

Administrator

Re: Problem: SqlDbx hangs on replace

I am unable to reproduce this issue in 3.27.
There was an issue with replace hangin in one of the previous releses
but it was fixed.

jweyrich

Member

Re: Problem: SqlDbx hangs on replace

Sorry, I forgot to mention it happens on SqlDbxPersonal-3.28-TEST.

Last edited by jweyrich (2009-01-28 07:31:02)

sqldbxhelp

Administrator

Re: Problem: SqlDbx hangs on replace

I am not sure where the problem, but I can not reproduce t.
Can you email exact text to support.
Thank your

jweyrich

Member

Re: Problem: SqlDbx hangs on replace

The problem also occurs using the same text posted above.
I've tested it over and over and found that it occurs only when you have all the statement indented twice.

The step-by-step is:

1. Copy+paste de statement above (except the 1st line, all the statement is indented twice, so indent the 1st line twice);
2. Select sql.append(" using the keyboard or mouse;
3. Press ctrl+c, press ctrl+home, press ctrl+h, press ctrl+v, press alt+a, press enter/return, press alt+c;
4. Select "); using the keyboard or mouse;
5. Press ctrl+c, press ctrl+home, press ctrl+h, press ctrl+v, press alt+a (it must hang now), press enter/return, press alt+c;
...

Let me know if it reproduces the problem for you.

sqldbxhelp

Administrator

Re: Problem: SqlDbx hangs on replace

Finally I was able to reproduce it.
This issue will be corrected in a next release.
For your help in resolving this issue we would
like to offer you free version of SqlDbx Professional.
Somebody will contact you soon.
Thank you

Last edited by sqldbxhelp (2009-01-30 13:01:08)

jweyrich

Member

Re: Problem: SqlDbx hangs on replace

Great. I thought it would be harder to reproduce.
And thank you for the offer.

senthurpandian

Member

Re: Problem: SqlDbx hangs on replace

Congrats jweyrich