SQL Anywhere 16 Sneak Peek: ISQL Text Completion

The ISQL Text Completion feature in SQL Anywhere 16 has been improved in three ways:

• it shows the parameter list when you type the opening "(" of a procedure or function call,
  

• it shows the closing bracket when you type an opening bracket, and
  

• it shows the closing quote when you type an opening quote.
  

Here's what the first two look look like:



The parameter list completion works for user-defined functions as well:

CREATE FUNCTION f (
   in parm1 INTEGER,
   in parm2 VARCHAR ( 100 ) )
   RETURNS VARCHAR ( 100 )
BEGIN
   RETURN 'Hello';
END;

The bracket completion works for all three "{", "[" and "(", and the quote completion works for double and single quotes:



To set your preferences for text completion see the ISQL Tools - Options... - Editor - Text Completion dialog box:

---