DOC: Misinformation in "setSQLText Method" Regarding Requery (190587)



The information in this article applies to:

  • Microsoft Visual InterDev 6.0

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.

Modification Type:MinorLast Reviewed:3/7/2005
Keywords:kbCtrl kbdocerr kbdocfix kbinfo KB190587