PRB: Recordset DTC moveAbsolute Does Not Work With QueryString
Article ID: 194024
Article Last Modified on 3/16/2005
APPLIES TO
- Microsoft Visual InterDev 6.0 Standard Edition
This article was previously published under Q194024
SYMPTOMS
The Recordset DTC moveAbsolute method will not work when a query string
variable is passed as the parameter (for example, rsDTC.moveAbsolute(4) vs
rsDTC.moveAbsolute(number) where "number" is a Query String variable
containing the number 4),
CAUSE
Query string varibles are by default a "string" datatype and the parameter
passes to the moveAbsolute method must be an integer.
RESOLUTION
Convert the variable to an integer type and then pass it to the
moveAbsolute method. In VBScript, you may use the cint function like this:
number = cint(variable)
Now you can pass "number" into the moveAbsolute method.
NOTE: This cannot be done in JScript or JavaScript because every variable
is an Object in JScript and JavaScript does not have an applicable type for
the moveAbsolute method.
STATUS
This behavior is by design.
Keywords: kbide kbprb kbctrl KB194024