Groups > microsoft.public.scripting.vbscript > #11240

Re: Return a key, value pair from a "for each" loop.

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.scripting.vbscript
Subject	Re: Return a key, value pair from a "for each" loop.
Date	2016-01-27 18:13 -0500
Organization	A noiseless patient Spider
Message-ID	<n8bioo$av2$1@dont-email.me> (permalink)
References	(2 earlier) <56a89de3$0$23772$e4fe514c@news.xs4all.nl> <n8auhe$a98$1@dont-email.me> <56a90ed5$0$23855$e4fe514c@news.xs4all.nl> <n8b62d$g8f$1@dont-email.me> <56a94543$0$23868$e4fe514c@news.xs4all.nl>

Show all headers | View raw

> I think I will either end up with this:
>
> for i=0 to oRecord.FieldCount-1
>   wscript.echo oRecord.GetFieldID(i) &" "& oRecord.GetFieldData(i)
> next
>
> or with this:
>
> for each oField in oRecord
>   wscript.echo oField.ID &" "& oField.Data
> next
>
> The latter one looks best but internally costs two extra objects (the
> enumerator and the field objects), while the former one does the 
> same, but
> is not as flexible -- a "for each" can easily internally skip records 
> on the
> run if needed (think filtering), a "for" loop needs the full count 
> upfront,
> so no sneaky dropping of certain entries.

That's how I see it as well. Your call, of course, depending on what 
your preference is (or requirement is) for parsing the record data.<g>

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 12:31 +0100
  Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-26 12:54 +0100
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 14:18 +0100
      Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-26 14:42 +0100
        Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 15:27 +0100
          Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-26 17:08 +0100
            Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 18:44 +0100
  Re: Return a key, value pair from a "for each" loop. "Mayayana" <mayayana@invalid.nospam> - 2016-01-26 08:26 -0500
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 16:41 +0100
  Re: Return a key, value pair from a "for each" loop. JJ <jj4public@vfemail.net> - 2016-01-27 01:01 +0700
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-26 20:41 +0100
      Re: Return a key, value pair from a "for each" loop. JJ <jj4public@vfemail.net> - 2016-01-27 16:56 +0700
        Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 13:16 +0100
          Re: Return a key, value pair from a "for each" loop. JJ <jj4public@vfemail.net> - 2016-01-28 04:16 +0700
            Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-28 00:17 +0100
            Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-28 00:22 +0100
              Re: Return a key, value pair from a "for each" loop. JJ <jj4public@vfemail.net> - 2016-01-28 16:03 +0700
                Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-28 11:59 +0100
  Re: Return a key, value pair from a "for each" loop. GS <gs@v.invalid> - 2016-01-26 18:10 -0500
    Re: Return a key, value pair from a "for each" loop. GS <gs@v.invalid> - 2016-01-26 18:12 -0500
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 11:33 +0100
      Re: Return a key, value pair from a "for each" loop. GS <gs@v.invalid> - 2016-01-27 12:27 -0500
        Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 19:42 +0100
          Re: Return a key, value pair from a "for each" loop. GS <gs@v.invalid> - 2016-01-27 14:36 -0500
            Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 23:34 +0100
              Re: Return a key, value pair from a "for each" loop. GS <gs@v.invalid> - 2016-01-27 18:13 -0500
                Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-28 09:49 +0100
  Re: Return a key, value pair from a "for each" loop. Ulrich Möller <knobbi38@arcor.de> - 2016-01-27 01:30 +0100
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 11:40 +0100
      Re: Return a key, value pair from a "for each" loop. Ulrich Möller <knobbi38@arcor.de> - 2016-01-27 15:08 +0100
        Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 15:51 +0100
  Re: Return a key, value pair from a "for each" loop. ttanaka@cybernet.co.jp - 2016-01-26 17:13 -0800
    Re: Return a key, value pair from a "for each" loop. "Mayayana" <mayayana@invalid.nospam> - 2016-01-26 21:28 -0500
      Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 12:41 +0100
        Re: Return a key, value pair from a "for each" loop. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-01-27 12:44 +0100
          Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 13:21 +0100
    Re: Return a key, value pair from a "for each" loop. "R.Wieser" <address@not.available> - 2016-01-27 11:43 +0100

csiph-web