Microsoft KB Archive/190587

= DOC: Misinformation in "setSQLText Method" Regarding Requery =

Article ID: 190587

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q190587



SUMMARY
The "setSQLText Method" topic in the Visual InterDev documentation states the following:

"In client script (Microsoft Internet Explorer 4.0 DHTML), using the setSQLText method will actually change the SQL property of the RDS control, thus causing a requery of the data source which resets the recordset."

This information is incorrect. The data source is not automatically requeried when the setSQLText method is used. This behavior is by design.



MORE INFORMATION
In client script, you can use the setSQLText method when the recordset is open (you don't have to close it first as you do with server-side), but you still must explicitly call the requery method.

Keywords: kbinfo kbdocfix kbdocerr kbctrl KB190587

-

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

© Microsoft Corporation. All rights reserved.