Can you add records to a recordset without adding

Results 1 to 2 of 2

Thread: Can you add records to a recordset without adding

  1. #1
    William Prugh Guest

    Default Can you add records to a recordset without adding

    Is it possible to create a recordset of data from a database table, then add records to the recordset in a for loop, without adding the records to the database.<BR><BR>If not desc = "" then<BR>For index = 1 to arraycounter<BR>&#039some manipulation<BR>&#039then the SQL <BR>SQLStmt = "SELECT *"<BR>SQLStmt = SQLStmt & "FROM contract "<BR>SQLStmt = SQLStmt & "WHERE [description] LIKE &#039" &currentword& "&#039;"<BR>&#039This is where its confusing<BR>&#039Can we set the recordset and then<BR>&#039continue to add records to it?<BR><BR>If index = 1 then<BR>Set RSWords = Connection.Execute(SQLStmt)<BR>End If<BR> &#039RSWords.movelast<BR>Set RSWords = RSWords & Connection.Execute(SQLStmt)<BR>&#039RSWords.Update <BR>SQLStmt=""<BR>Next<BR> <BR>End If

  2. #2
    blah Guest

    Default RE: Can you add records to a recordset without add

    yes it is possible, but you need to put the record into a array of dictionary object, or something similar..<BR><BR>you&#039d have, rows[0].recorditem("blah")...<BR><BR>yeah, it requires some codes, but it works

Posting Permissions

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