Join  |  Sign in
sql parser

16-Jul-2017 04:13 AM

In over my head

In over my head

Posts: 2

Downloaded the Editor today and am testing for an application I am building.   Need either the MSSQLParser or sqlParser functionality.  

Browsed the Quantum Whale forums and found related posts to my question.  Response was always in a private email.

Much of the code is highlighted as incorrect syntax.  Is there something I need to be including or changing that you know of?  

  Reply

17-Jul-2017 04:58 PM

Andrew Medvedev

Andrew Medvedev

Posts: 50

Hi,

Mssql parser supports only a select query statement. Could you send me (Andrew.medvedev@alternetsoft.com) example of sql that it fails to parse?

regards,
Andrew
  Reply

18-Jul-2017 01:09 AM

In over my head

In over my head

Posts: 2

Thank you for the response Andrew.   One example in MSSQL is the use of BEGIN...END; blocks.  These will be highlighted as incorrect syntax.  Another example is and UPDATE statement.

UPDATE bk SET name = 'AlterNet Forever' FROM Book bk WHERE name = 'AlterNet Sometimes' 

This is not a pressing issue with me.  I could just disable the highlighting for now.  





  Reply