Cursor Layout

• 

  Tobyh wrote:

  When you layout CURSORs, I can't find any way to indent the SELECT statement.
  
  /*Current*/

  DECLARE Test CURSOR Fast_Forward FOR SELECT Col1,
                                              Col2
                                              FROM Tester
  OPEN TEST
  

  
  /* Ideal */

  DECLARE Test CURSOR FAST_FORWARD FOR
      SELECT Col1,
             Col2
      FROM Tester
  OPEN Test
  

  
  Also the Cusor name is made uppercase after the OPEN call and the rest of the CURSOR.
  
  Otherwise this is fantastic product, I will be getting a copy.

  
  In this beta we have not finished cursor support, but as a workaround would be to add a newline before the select keyword, and apply layout only to the select statement (the SQL Lay Out works on selections as well).
  
  We will improve cursor support in the final release.
  
  Regards,
  Andras

  Andras B October 06, 2006 07:06

  - 0 +
• 
  Excellent, can't wait.
  Been doing the workaround.

  In this beta we have not finished cursor support, but as a workaround would be to add a newline before the select keyword, and apply layout only to the select statement (the SQL Lay Out works on selections as well).

  
  Thanks !

  Tobyh October 06, 2006 07:19

  - 0 +

Add comment

Please sign in to leave a comment.