How do you update a dbase

Results 1 to 2 of 2

Thread: How do you update a dbase

  1. #1
    Join Date
    Dec 1969

    Default How do you update a dbase

    &nbsp;<BR>how do up update a dbase using this format:<BR><BR>set rs=Server.CreateObject("adodb.Recordset")<BR>rs.Op en "tblTechnologydirectory", dbcon, adOpenKeySet, adLockOptimistic, adCmdTable<BR>rs.AddNew<BR>rs("tdorderrouting") = tdorderrouting<BR>rs("tdreconciliations") = tdreconciliations<BR>rs("tdordermanagement") = tdordermanagement<BR>rs.Update<BR>newtdid = rs("tdid")<BR>rs.close<BR>dbcon.close<BR><BR>Redee m<BR>

  2. #2
    Join Date
    Dec 1969

    Default move to the record

    you want and use .Update<BR><BR>(leave out the .AddNew)<BR><BR>but it&#039;s better to use a SQL string <BR><BR>UPDATE table<BR>SET field = NewValue<BR>WHERE somefield = whatever

Posting Permissions

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