| Author |
Message |
|
|
Post subject: SQL Explorer Syntax Highlighting
 Posted: Aug 30, 2004 - 07:33 PM
|
|
Veteran Member
Joined: Nov 01, 2003
Posts: 120
|
|
| I noticed, that if I pull in an external file the syntax highlighting does not work properly. |
|
|
| |
|
|
|
 |
|
|
|
Post subject:
Posted: Aug 31, 2004 - 05:44 AM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23306
|
|
| What kind of file? What version of Eclipse/ME are you using? What do you mean "pull in"? |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 04:01 PM
|
|
Veteran Member
Joined: Nov 01, 2003
Posts: 120
|
|
| 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. |
|
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 05:04 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23306
|
|
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. |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 07:03 PM
|
|
Veteran Member
Joined: Nov 01, 2003
Posts: 120
|
|
| 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. |
|
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 07:09 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23306
|
|
| Is this just a problem with the syntax highlighting, or only when you open an exteranl file? |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 07:15 PM
|
|
Veteran Member
Joined: Nov 01, 2003
Posts: 120
|
|
| Just syntax highlighting. When I execute the query it works just fine. |
|
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 08:53 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23306
|
|
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. |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 09:02 PM
|
|
Veteran Member
Joined: Nov 01, 2003
Posts: 120
|
|
| 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. |
|
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Aug 31, 2004 - 09:10 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23306
|
|
| 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@myeclipseide.com with a reference to this thread? |
_________________
Riyad
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: Sep 01, 2004 - 12:59 AM
|
|
Registered Member
Joined: May 27, 2004
Posts: 5
|
|
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...?? |
|
|
| |
|
|
|
|
|
|
Search
Register
Log in to check your private messages
