Microsoft KB Archive/191149

= BUG: setParameter Does Not Work in Client Scripting Platform =

Article ID: 191149

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q191149



SYMPTOMS
When DTC Scripting Platform is set to Client (IE 4.0 DHTML), the getParameter and setParameter methods fail to function on the Recordset design-time control (DTC). This affects stored procedures and parameterized queries.

In addition, when DTC Scripting Platform is set to Client (IE 4.0 DHTML), the getParameter and setParameter methods do not appear in the IntelliSense drop-down list box.



CAUSE
The Client DTC Scripting Platform does not support the getParameter and setParameter methods.



RESOLUTION
The workaround for this issue is to set the setSQLText property so that the parameters are a part of the SQL statement.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The setParameter and getParameter methods fail from the client scripting platform. For example: rsByRoyalty.setParameter(0, 50);  //This fails.

Recordset1.setSQLText("Select * from authors where state = ?"); Recordset1.setParameter(0, "CA"); //This fails. The following examples demonstrate how to set the setSQLText property to obtain the functionality of a stored procedure with parameters or a parameterized query: Recordset1.setSQLText('"byroyalty" 50');

Recordset1.setSQLText("Select * from authors where state = 'CA'");

Keywords: kbbug kbpending KB191149

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.