Skip to Content

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:

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply