Wednesday, February 20, 2013

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:




No comments: