CLOB edition problems

SQL Navigator
1

Hi

I got the following clob editing problems:
build 1838 (6.3.1)

  • cut -paste gets newline char at some point
  • if you cut-paste into a wrap lines editor a newline gets pus at the wrap point
  • loading from file: it appends(!!) when the file is correctly openned but with some files only the chars ÿþ/ appear but the status line says the correct info from the file

-when using delete in the grid above a clob field the (CLOB) display doesn’t change to (Null)

Regards
Filipe

2

Hi Filipe,

I couldn’t reproduce the first issue you listed, but I will create CRs for last two. Thanks for reporting them.

Vincent

3

Sorry the 1st and the 3rd one are what I could not reproduce. I have created CRs for the 2nd and the 4th.

Thanks,
Vincent

4

1st : - cut -paste gets newline char at some point
I found out that the point its at 1024 at each line (like the editor makes)

5

3st: what you could not reproduce: the append or the ÿþ/ ?

6

Is this issue perhaps similar to the one raised in the following post?

http://sqlnavigator.inside.quest.com/message.jspa?messageID=88435#88435

7

yes, Annelize you are right, that it’s the 1st issue I reported.

8

I tested now with 6.4 beta build 1881 and

  • 1st issue fixed
  • 2st issue fixed
  • 3st issue still happens but the append is made to the end of the content and not at the beginning like in 6.3.1
    -4st issue still occurs

Regards
Filipe

PS: The append of only the strange chars occurs to me with a file that has a line bigger than 1024 char

Message was edited by: Fsilva

9

with 6.4 beta build 1881:

the horizontal scroll bar doesn’t go all the way to the end of the line (if the line is big)
vertical scroll bar seems to scroll to much when a line is to big (like if it was “looking” for the wrapped lines (at 1024 char))

Regards
Filipe

10

beta 6.4.0.1913

loading from file: it appends(!!) when the file is correctly openned but with some files only the chars ÿþ/ appear
=>NOT FIXED: I still do not know if appending is a feature or a bug but now it appends at the cursor. with a 53K file only the chars ÿþ/ appear

when using delete in the grid above a clob field the (CLOB) display doesn't change to (Null)
=>NOT FIXED

the horizontal scroll bar doesn't go all the way to the end of the line (if the line is big) => FIXED

vertical scroll bar seems to scroll to much when a line is to big (like if it was "looking" for the wrapped lines (at 1024 char))
=>NOT FIXED

Message was edited by: Fsilva

11

With version 6.6 (build 2293) the load of a file in a clob field still appends the content of the file to the begging of the content …not replacing !