Knowledge Base

DOC: Misinformation in "setSQLText Method" Regarding Requery

Article ID: 190587

Article Last Modified on 3/7/2005

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.