Home    Product home page    Download    Order
Contents
Introduction
Features
Other MicroOLAP Products
Tutorials
Interface User Guide
Diagram
Diagram Objects
Database
Tables
Columns
Domains
References and Foreign Keys
Indexes
Stored Procedures and Functions
Creating a Stored Procedure or Function
Stored Routine Editor
Stored Routine Manager
Triggers
Views
Notes
Stamps
Diagram Functions
Database Functions
Database Accessing Tools
Reverse Engineering And Import
Data Functions
Reports
Printing a Diagram
How to...
Installation
Purchase
Translation
Support
License
Glossary

Glossary Item Box

See Also Database Designer for MySQL Send feedback on this topic

Creating a Stored Procedure or Function

Creating a Stored Procedure or Function

  1. To create a new procedure (later on you can switch it to a stored function), click on the Stored Procedure () icon on the Palette toolbar. Your mouse cursor will change its appearance. Click on the diagram area to create a new stored procedure. A rectangle with the name of the stored procedure will appear in the diagram:
  2. (Optional). To switch procedure to the function double click the routine rectangle. The Stored Routine Editor will be shown. Go to the Definition tab and select Function from the Routine type drop-down list. Click OK to save your changes.

     

To edit parameters of the stored procedures and functions use Stored Routine Editor.

Stored Procedures and Functions | Stored Routine Manager

 

 

©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.