Gets properties of the object as determined by the inputs. This VI works for connections, commands, recordsets, columns, and parameters. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.


icon

Inputs/Outputs

  • cdlrn.png recordset reference —

    recordset reference specifies a reference to an ADO Recordset object.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • idlrn.png recordset reference out —

    recordset reference out returns a reference to an ADO Recordset object.

  • icclst.png recordset properties —

    recordset properties returns the various properties associated with a recordset object.

  • ii32.png column count —

    column count returns the number of columns in the recordset.

  • ii32.png record index —

    record index returns the zero-indexed position of the current record in the recordset. Some providers or cursor types do not support this property. A value of -2 means that the property is not supported. Values of -3 and -4 indicate that the index is located at Beginning Of File (BOF) and End Of File (EOF), respectively.

  • ii32.png record count —

    record count returns the number of records in the recordset. Some providers or cursor types do not support this property. If this property is not supported, record count returns -1.

  • ibool.png bof? —

    bof? if TRUE, the cursor points at the Beginning Of File (BOF). BOF is defined as the position before the first record in the recordset. If both BOF and End Of File (EOF) are TRUE at the same time, records do not exist in the recordset, and navigation of the recordset returns an error.

  • ibool.png eof? —

    eof? if TRUE, the cursor points at the End Of File (EOF). EOF is defined as the position after the last record in the recordset. If both Beginning Of File (BOF) and EOF are TRUE at the same time, records do not exist in the recordset, and navigation of the recordset returns an error.

  • ienum.png cursor type —

    cursor type returns the method used to navigate the recordset. Some providers and/or databases do not support all types of cursors.

  • ii32.png cache size —

    cache size returns how many records are kept in local memory.

  • ienum.png state —

    state returns the state of the recordset. If the recordset is closed, the recordset does not contain any records. A non-row-returning query returns a closed recordset. Many fetching functions return errors if the functions are performed on closed recordsets, so check for errors.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.