Sybase SA 22.214.171.12467 or Sybase SA 126.96.36.1994
In the code editor, such as Sybase ISQL has a line like MYTABLE.MYFIELDNAME.
When you double-click mouse on the side lines (on the MYTABLE or MYFIELDNAME) allocates the entire line as a whole, not just the part of the line on which i clicked the mouse. It turns out that the code editor ignoring delimiters SQL constructs in the allocation line.
Need to fix it.
asked 26 Nov '13, 03:30
Thank you for the explanation.
Unlike other scenarios, I think this is somewhat a matter of opinion of what is the "right thing to do"...
So in version 12, there are further enhancements to the SQL syntax for SQL Anywhere. For instance, we introduced SEQUENCES that have the following syntax:
If I'm editing in dbisql, I probably do not want to just select the "mysequence" identifier without .nextval (a "dotted expression").
However, if I use any identifier mark in my SQL it is then clear what is supposed to happen and DBISQL will select just the identifier you're selecting:
Version 16 also introduced the ROW type which uses dotted expressions.
In summary, the SQL you have posted is not clearly an "identifier" or a "dotted expression", so currently you will need to add identifier marks (double-quotes (""), square-brackets () or back quotes (``)) to make it clear what you want dbisql to do.
answered 15 May '14, 11:41