DOC: Misinformation in "setSQLText Method" Regarding Requery

ID: Q190587

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

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.

Additional query words:

Keywords : kbdocfix kbdocerr kbVisID kbVisID600 kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type :