How to exclude fields from the GetString() method?

From: Chris H (chorton7777_at_hotmail.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 19:59:18 -0400

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: Recordset used in Select/Option pick list
    ... All it is is a string. ... to the list of options generated from your recordset. ... Result of GetString: ... Please reply to the newsgroup. ...
    (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: Recordset used in Select/Option pick list
    ... Rather than the first recorder in my recordset ... Result of GetString: ... What the getstring is doing is constructing a string from all the data ... My next step it to add the beginning option tag to the string and strip ...
    (microsoft.public.data.ado)
  • Re: String vs. Collection
    ... Depending on what database I am connecting, ... Now I know why concatanating a string is slow in VB6, ... think leavine the data in the recordset may be a better ...
    (microsoft.public.vb.enterprise)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)