for each with a record set

Results 1 to 2 of 2

Thread: for each with a record set

  1. #1
    Rob Guest

    Default for each with a record set

    I have a record set with several repeating values. I only want the individual values. How do you do a for each loop with a record set? Is there a way to do it in the SQL that i am unaware of. I can find no info or examples of a for each with a recordset anywhere.<BR><BR>Thanks,<BR><BR>Rob

  2. #2
    Join Date
    Dec 1969

    Default RE: for each with a record set

    I don&#039t think I am getting you here. Are you trying to just get the Distinct values. If so, on your SQL, you could do something like SELECT DISTINCT fieldname FROM tablename ...<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts