Re: How to exclude fields from the GetString() method?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Val Mazur (group51a_at_hotmail.com)
Date: 08/06/04 

Date: Thu, 5 Aug 2004 22:14:47 -0400

Hi Chris,

You cannot control selected fields in a GetString method. What you could do
is to use GetRows method to dump info into array first and then convert it
into the string using your own code. I think it would work faster than to
create another recordset based on a first one, but with selected fields
only, but you could go this way as well 

-- 
Val Mazur
Microsoft MVP
"Chris H" <chorton7777@hotmail.com> wrote in message 
news:uZVWTYbeEHA.3928@TK2MSFTNGP11.phx.gbl...
> Hello All,
>
> I have like 20 fields in a recordset and I want to use the GetString()
> method to get a large string to compare against another recordset.
>
> The problem is I want to be able to exclude certain fields from being
> extracted. The fields I want to exclude *must* be in the recordset but I
> don't want to see them when I do the GetString() method. Is there any way 
> I
> can hide those fields?
>
> What type of fields are *not* exported when I use GetString()?
>
> The GetRows() method allows me to specify the columns I do want but I only
> need a basic string for the row, not an array.
>
> Thanks in advance guys.
>
> Chris H
>
>

Relevant Pages

  • Re: How to exclude fields from the GetString() method?
    ... "Chris H" wrote in message ... > shape recordset as a parent query.... ... > "Val Mazur" wrote in message ... >>> I have like 20 fields in a recordset and I want to use the GetString() ...
    (microsoft.public.data.ado)
  • How to exclude fields from the GetString() method?
    ... I have like 20 fields in a recordset and I want to use the GetString() ... method to get a large string to compare against another recordset. ... The fields I want to exclude *must* be in the recordset but I ...
    (microsoft.public.data.ado)
  • Re: Recordset used in Select/Option pick list
    ... Result of GetString: ... What the getstring is doing is constructing a string from all the data ... since there is only one field in the recordset, ... My next step it to add the beginning option tag to the string and strip ...
    (microsoft.public.data.ado)
  • Re: export to textfile then import
    ... You may take a look at GetString and GetRows methods of Recordset. ... or you can use the same Split function to create that array of names. ... > Thinks Dmitriy for the quick response. ...
    (microsoft.public.vb.general.discussion)