Edit a procedural routine object in its associated editor.
You can edit a procedural routine object to modify or add more SQL statements. You can add to the body of the procedural routine object either manually or by using Visual SQL or Content Assist.
Database | Steps |
---|---|
From an ASE connection profile |
|
From a SQL Anywhere or Sybase IQ connection profile |
|
Procedural object | Description |
---|---|
Stored procedures | Expand the Stored Procedures folder. |
SQL Anywhere or Sybase IQ User-defined functions | Expand the User Defined Functions folder. |
Triggers | Expand the Tables folder, select the table in which the trigger resides, and then expand the Triggers folder. |
SQL Anywhere or Sybase IQ events | Expand the Events folder. |
To | Do this |
---|---|
Edit manually | Start typing. |
Use Visual SQL | Create a new SQL select, insert, update or delete statement at the current cursor location. To access Visual SQL, right-click and select any of the SQL commands menu choices. |
Use Content Assist | In the source code, press Ctrl+Space to display a list of syntax options available to you at the cursor point in your SQL code. Select the appropriate syntax to enter into the code by double-clicking it or by pressing Enter. Alternatively, an auto-invocation feature displays appropriate syntax lists when you pause after typing in certain characters, for example, '.', ',', '@'. These lists are more specific to the context and allow you to view, for example, a list of all table names in a database. |
Display line numbers | Right-click in the left margin and select Show Line Numbers. |
To | Do this |
---|---|
Save the object to the same SQL file | Select | from the main menu.
Save the object to a different SQL file and/or project | Right-click and select Save As. |
Save the object to the database server | Right-click and select Save to Database. |