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: