Viewing Parameter Information at Design Time

From InterBase

Go Up to Working with Stored Procedures

If you have access to a database server at design time, there are two ways to view information about the parameters used by a stored procedure:

  • Invoke the SQL Explorer to view the source code for a stored procedure on a remote server. The source code includes parameter declarations that identify the data types and names for each parameter.
  • Use the Object Inspector to view the property settings for individual TParam objects.

You can use the SQL Explorer to examine stored procedures on your database servers. If you are using ODBC drivers, you cannot examine stored procedures with the SQL Explorer. While using the SQL Explorer is not always an option, it can sometimes provide more information than the Object Inspector viewing TParam objects. The amount of returned information about a stored procedure in the Object Inspector depends on your database server.

To view individual parameter definitions in the Object Inspector:

  1. Select the stored procedure component.
  2. Set the Database property of a stored procedure component to the Database property of a TIBDatabase.
  3. Set the StoredProcName property to the name of the stored procedure.
  4. Click the ellipsis button in for the TIBStoredProc.Params property in the Object Inspector.
  5. Select individual parameters in the collection editor to view their property settings in the Object Inspector.

For some servers, some or all parameter information may not be accessible.

In the Object Inspector, when viewing individual TParam objects, the ParamType property indicates whether the selected parameter is an input, output, input/output, or result parameter. The DataType property indicates the data type of the value the parameter contains, such as string, integer, or date. The Value edit box enables you to enter a value for a selected input parameter.

For more about setting parameter values, see Setting Parameter Information at Design Time.

You can never set values for output and result parameters. These types of parameters have values set by the execution of the stored procedure.

Advance To: