Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Brian Vivian: "Thank you very much for making such a great product. It makes my job a LOT easier".
Carl Schammel: "I have been in search of a software product that was rich in features and easy for using, but was unable to find one until I came upon Firebird Maestro. Not only does it have all-inclusive integrated functionality, but SQL Maestro Group have provided me with superior support. I now have the management tools at my hand that I have been looking for".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Parameter Editor

The editor allows you to change the Parameter name, Data type (Firebird 2.1+ supports using of domains on declaring the data types of arguments in stored procedures),  and the Default value that specifies a parameter value to be used when no value is explicitly supplied.
 

Use the Scope box to set whether parameter is Input, or Output

 

 

Mechanism (for UDFs)

Set the return mechanism of the UDF parameter (The property is available when the IS RETURN option is checked). The available mechanisms are:

BY REFERENCE: specifies that the return value should be passed by reference;
FREE IT: frees memory of the return value after the UDF finishes running;
BY VALUE: specifies that the return value should be passed by value;
BY DESCRIPTOR: specifies that the return value should be passed by descriptor.

 

Is Return (for UDFs)

If checked, the UDF returns this parameter.

 

Use the Size edit box to define the length of the parameter value for float, char and other data types and the Precision edit box to define the precision of the parameter value, e.g. for decimal data type.

 

Charset

Define the charset for the CHAR and VARCHAR data types.

 

Check the Suppress domain check values box (available if a domain has been selected as parameter data type) to declare the argument or variable using the data type of the domain, without inheriting CHECK constraints and the DEFAULT value (if declared in the domain).



Prev Return to chapter overview Next