Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Feb 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Possible methods of recordset object?

    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();

    function initializeArray()
    &#160 {
    &#160&#160 recordSet.BOF;
    &#160&#160 for(var i=0; !recordSet.EOF; i++)
    &#160&#160&#160 {
    &#160&#160&#160&#160 myArray[i] = recordSet.Insert Method Here ;
    &#160&#160&#160&#160 recordSet.MoveNext();
    &#160&#160&#160 }
    &#160 }
    Last edited by rtainge; 02-13-2004 at 04:38 AM.

  • #2
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,033
    Thanks
    0
    Thanked 248 Times in 245 Posts
    Here's the ADO Recordset Reference

    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.

  • #3
    Regular Coder
    Join Date
    Feb 2003
    Posts
    638
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There's a Tabular Data Control Reference in the SDK.

    For less documented objects, the OLE/COM Object Viewer allows you to view their type library, which lists all methods (look in the CoClasses section of the typelib).
    hmm... ?

  • #4
    New to the CF scene
    Join Date
    Feb 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #5
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,033
    Thanks
    0
    Thanked 248 Times in 245 Posts
    I just assumed TDC uses ADO to access the database. Of course, I might be wrong, I haven't used TDC before. And I know GetRows() is a VBScript function. Actually, you can use the VBScript ADO reference in javascript (of course, in IE only). Just follow the camelCasing naming convention of properties and methods in Javascript.
    i.e. GetRows() --> getRows()

  • #6
    Regular Coder
    Join Date
    Feb 2003
    Posts
    638
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    hmm... ?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •