Non highlighted text is being syntax checked:

• 

  drsql wrote:

  The following is the batch:
  

  ---

  Check this out:
  
  select *
  from bob --a table I have created
  
  select *
  from bob
  

  ---

  
  I highlight only one of the select * from bob and the following error is raised:
  

  ---

  Document Contains Invalid SQL Syntax

  ---

  SQL Refactor was unable to fully qualify this script because some errors were found while it was being parsed. These errors have been highlighted.

  ---

  OK

  ---

  
  Commenting out the text allows everything to work. Layout SQL, Uppercase keywords, works, but not Qualify Object Names or Expand Keywords.
  
  The only text that your parser should see should be what is highlighted (or at least a way to do that as needed)
  
  I write a lot of commentary like that. Writing the text in SSMS, edting the text along with the queries and then past the text into Notepad (to expunge formatting) and finally into the blogging tool.

  
  
  Hi,
  
  we must go through the whole file and check its syntax, even though you have selected only a part of the script. There are many reasons for it. Among them are:
  - we follow up use statements, and use them to resolv database objects
  - we consider nestedness, so if you select something inside an if statement, we will indent with consideration to it
  - CTE expressions
  
  However, we do higlight problems that have caused a syntax check error.
  This was a design decision we had to make to support nested and multi database scripts.
  
  Regards,
  Andras

  Andras B October 09, 2006 05:41

  - 0 +

Add comment

Please sign in to leave a comment.