Accessing Parameters at Design Time

From InterBase

Go Up to Understanding Stored Procedure Parameters


If you connect to a remote database server by setting the Database and StoredProcName properties at design time, then you can use the StoredProc Parameters editor to view the names and data types of each input parameter, and you can set the values for the input parameters to pass to the server when you execute the stored procedure.

Important:
Do not change the names or data types for input parameters reported by the server, or when you execute the stored procedure an exception is raised.

Some servers do not report parameter names or data types. In these cases, use the SQL Explorer or IBConsole to look at the source code of the stored procedure on the server to determine input parameters and data types. See the SQL Explorer online help for more information.

At design time, if you do not receive a parameter list from a stored procedure on a remote server (for example because you are not connected to a server), then you must invoke the StoredProc Parameters editor, list each required input parameter, and assign each a data type and a value. For more information about using the StoredProc Parameters editor to create parameters, see Setting Parameter Information at Design Time.

Advance To: