Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003

    Unanswered: update statement

    I need to update a table. Everything is a variable. The total number of fields in that table can vary and what those fields are, can also vary.

    I need to take the value from each field in that table and run it through a udf if that field is not NULL.

    I have to write a single update statement for the following:

    For Each fldLoop In rs.Fields
    strResult = dbo.mudf0_ProperCase(fldLoop.Value)
    rs.Fields(fldLoop.Name) = strResult
    Next fldLoop

    Here rs is a recordset that contains everything from a table strTable.

    Please suggest how this can be accomplished.

    Thanks much.
    Last edited by archnam; 09-15-03 at 17:36.

Posting Permissions

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