RPCRebind

Description

Specifies whether you want DataWindow Designer to rebind Remote Procedure Call (RPC) parameters.

When to specify RPCRebind If your back-end DBMS supports it, you must specify the RPCRebind parameter before connecting to the database.

Applies to

ODBC

Syntax

RPCRebind = value

Parameter	Description
value	Specifies whether you want DataWindow Designer to rebind RPC parameters. Values are: 0 (Default) Use the bound variable to determine all required binding information. 1 Rebind the parameters and use the parameter information returned from the database to bind the parameter.

Parameter

Description

value

Specifies whether you want DataWindow Designer to rebind RPC parameters. Values are:

0 (Default) Use the bound variable to determine all required binding information.
1 Rebind the parameters and use the parameter information returned from the database to bind the parameter.

Default

RPCRebind = 0

Usage

For those DBMSs that support RPC calls, DataWindow Designer binds the parameters for the call based on the size of the variables bound to the parameters.

Some drivers require rebinding of the parameters so the parameter size (as returned from the back-end database) is used instead of the variable size. Failure to do this might result in an error or truncation for string parameters. However, some drivers always expect the binding to reflect the variable size. The RPCRebind parameter allows you to specify whether you want to rebind the parameters when RPCs are executed.

Examples

Example 1

To specify that DataWindow Designer should rebind RPC parameters:

Database profile Select the RPC Rebind check box on the Transaction tab in the Database Profile Setup dialog box.
Application Type the following in code:
```
SQLCA.DbParameter = "RPCRebind=1"
```