Selecting particular columns in ADO using getstring

Question

When we use getstring to get data from a recordset (ADO) then it returns all the columns.

If only certain columns are required, how do we modify the getstring statement?

THanks but i found a way just used recordset.fields(x) to get those columns i needed thanks for having a look — tksy, Nov 18 '08 at 10:24
What does Access have to do with it? What environment are you coding in? — David-W-Fenton, Nov 21 '08 at 04:54

score 3 · Accepted Answer · answered Nov 18 '08 at 11:42

3

You can take a step back and build the recordset with only the fields (columns) that you want, for example:

strSQL="SELECT ID, FName, SName FROM Members"
rs.Open strSQL, cn

a=rs.GetString

answered Nov 18 '08 at 11:42

Fionnuala

90,370
7
114
152

score 2 · Answer 2 · answered Nov 18 '08 at 10:16

2

You can't. GetString returns all columns of all or a specified number of rows. You'll need to loop through the recordset, getting the columns you want explicitly.

It's all in the documentation.

answered Nov 18 '08 at 10:16

Tor Haugen

19,509
9
45
63

Philippe Grondier · Answer 3 · 2008-11-18T18:57:22.567

You can also use a combination of join and getrows

myString = join(rs.getrows( , , myColumn),";")

rsGetrows returns an array containing only the myColumn's values
Join will transfer the array in a string like "value1;value2; ..."

Check the exact syntax as this was written on the fly

EDIT: unfortunately, it cannot be that straight as .getrows will return a 2 dimensions array. Are there any functions that can extract a one dimension array from a 2 dimensions one? It can be written easily, can't it?

Selecting particular columns in ADO using getstring

3 Answers3