View Full Version : Possible methods of recordset object?
02-13-2004, 05:32 AM
I would like to populate an array with specific data from an Active X TDC object, however, the only methods I can find on the subject are: BOF(), EOF(), absolutePosition(), MoveFirst(), MoveLast(), MoveNext(), & MovePrevious(). The only properties that I can find are Sort, Filter, and Reset. Does anyone know what the available methods and properties are, or where I can find that information? Thanks in advance! Here is the function for more clarification.
var recordSet = myObject.recordset;
var myArray = new Array();
for(var i=0; !recordSet.EOF; i++)
myArray[i] = recordSet.Insert Method Here ;
02-13-2004, 05:54 AM
Here's the ADO Recordset Reference (http://www.devguru.com/Technologies/ado/quickref/recordset.html)
If you want to put the content of the recordset into an array, you don't have to loop through the recordset. Use the getRows() method.
There's a Tabular Data Control Reference (http://msdn.microsoft.com/workshop/database/tdc/reference/Tabular_Data_Control_ref_entry.asp) in the SDK.
For less documented objects, the OLE/COM Object Viewer (http://www.microsoft.com/com/resources/oleview.asp) allows you to view their type library, which lists all methods (look in the CoClasses section of the typelib).
02-13-2004, 04:55 PM
The object is a TDC, not an ADO recordset. GetRows() is a VBscript function. Please read posts before responding.
I believe that I may have found a possible workaround for the problem, but I would still like to know if there are any other methods available to this type of object. If the solution works, I will post it.
02-16-2004, 02:39 AM
i.e. GetRows() --> getRows()
Originally posted by rtainge
The object is a TDC, not an ADO recordset... Please read posts before responding.
It seems that the real problem was not that glenngv misread your post:
All methods you referred to are part of the ADO type libraries; none of them belong to the TDC.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.