Re: DAO - Column rather than row

Try forcing the recordset to go to the end before you get the record count.

By the way did you post the entire procedure?
rs.MoveLast
data = rs.GetRows(rs.RecordCount)

"Dan" <dp_pearce@xxxxxxxxxxx> wrote in message
news:1156978218.628134.179300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Please excuse me if this is a novice question. I am a bit away from my
confort zone with this as I am using a DAO link to interface with
Matlab.

I want to get values from an mdb file. I am looking to pull whole
columns of data at a time but have so far only managed to get each row.

q = hDB.CreateQueryDef('','SELECT * FROM tbl_QueryPeriod')
rs = q.OpenRecordset
data = rs.GetRows(rs.RecordCount)

Is there a way to get the whole column rather than a whole row?

Kind regards

Dan



.

Relevant Pages

  • how to get number of rows returned by a SqlDataReader?
    ... even the recordset doesn't know how many rows it ... forcing the entire dataset to be read. ... >how to get number of rows returned by a SqlDataReader ... >scroll it? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Performing column value changes when filling a dataset
    ... After you populate the DataTable you can add a new DataColumn ... > I pull back securityinfo and populate that in a dataset. ... > create an in-memory ADO recordset and set up all of the columns. ...
    (microsoft.public.dotnet.framework.adonet)
  • Performing column value changes when filling a dataset
    ... I have an application where extra data needs to be added to additional ... I pull back securityinfo and populate that in a dataset. ... Create an in-memory dataset and set up the columns (perhaps ... create an in-memory ADO recordset and set up all of the columns. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Changing Rows Data in Form RecordSet Results
    ... > result based on search criteria. ... > When they pull these records back they are showed on ... > single line continous forms in the child sub form. ... > button would check each box for each row in the recordset ...
    (microsoft.public.access.formscoding)
  • Changing Rows Data in Form RecordSet Results
    ... I have a screen that shows continous forms in a child sub ... result based on search criteria. ... When they pull these records back they are showed on ... button would check each box for each row in the recordset ...
    (microsoft.public.access.formscoding)