Results 1 to 3 of 3

Thread: incorrect syntsx near 'set' (resolve)

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908

    incorrect syntsx near 'set' (resolve)

    Code:
     objCmd.CommandText = " UPDATE DataBase_T " & _
                        " SET Description = ' " & txtD1.Text & " ' , " &  _
                        " SET Qty = ' " & txtQ1.Text & " ' , " & _
                        " SET Unit_Cost = ' " & txtUC1.Text & " '  " &  _
                        " WHERE Description = ' " & describe & " ' and Qty = ' " & qty1 & " ' and Unit_Cost = ' " & uc & " ' and PR_NO = ' " & Label15.Caption & " '  "
     objCmd.CommandType = adCmdText
    objcmd.Execute
    wat could go wrong?
    Last edited by Goh; Feb 17th, 2004 at 03:58 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width