facebook

SQL Explorer Syntax Highlighting

  1. MyEclipse Archived
  2.  > 
  3. Bugs
Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • #213991 Reply

    I noticed, that if I pull in an external file the syntax highlighting does not work properly.

    #214019

    Riyad Kalla
    Member

    What kind of file? What version of Eclipse/ME are you using? What do you mean “pull in”?

    #214063

    I am using Eclipse version 3.0, MyEclipse 3.81 with Fixpack 3. By pull in, I mean I open a SQL Editor window, then I click on open. The file I pull in IS NOT contained within any project within Eclipse, but it is contained in a random [Not really random]. I have found that if the SQL is contained within an Eclipse project though that the highlighting works properly.

    #214073

    Riyad Kalla
    Member

    Here is what I did:
    1) Open a table, geneerate SQL
    2) Save its contents to a file on my desktop
    3) Change the contents of the desktop file
    4) Click on “Open” and open the file from my desktop
    5) The file opened with correct syntax highlights on the SQL keywords…

    Is this not the behavior you are seeing? For reference I used the “mysql” table from a default MySQL install.

    #214105

    This is the behavior I had, but my query was pretty complex. I have inner tables being created along with several left outer joins, column aliasing, etc.

    #214107

    Riyad Kalla
    Member

    Is this just a problem with the syntax highlighting, or only when you open an exteranl file?

    #214110

    Just syntax highlighting. When I execute the query it works just fine.

    #214123

    Riyad Kalla
    Member

    Sorry, what I mean is there something wrong ALWAYS with this script or only when its opened as an external file? I’m trying to determine if the syntax highlighter is having a problem parsing the complexities of your statement or if its just a bad initialization step when the file is opened from outside of the project.

    Sorry I should have clarified.

    #214126

    I think it is when it gets pulled in, I just pulled it from the “SQL History” window and it works fine now. But when I initally pull it in, the highlighting does not work. Maybe it has to do with the file load process.

    #214128

    Riyad Kalla
    Member

    Thank you for the detail, I will ask the dev about it. Do you mind posting the script so we can use it as a test case? If not, can you email it to us at support@genuitec.com with a reference to this thread?

    #214163

    bonevich
    Member

    I need to see the script. Also, are there any errors in the Eclipse error log related to the DB Explorer?

    To be clear, we are talking about opening an external file, correct? You go to File->Open External File…??

Viewing 11 posts - 1 through 11 (of 11 total)
Reply To: SQL Explorer Syntax Highlighting

You must be logged in to post in the forum log in