SQL doubt

Results 1 to 5 of 5

Thread: SQL doubt

  1. #1
    William Guest

    Default SQL doubt

    Hi,<BR>Can someone tell me about "sql update"? I am actually searching for a product name and decreasing its quantity by one.<BR>Thanks,<BR>William

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL doubt


  3. #3
    Join Date
    Dec 1969

    Default SQL is the saviour

    You mean like<BR><BR>sql = "update products set quantity = quantity - 1 where name = &#039;" & replace(name,"&#039;","&#039;&#039;") & "&#039;"<BR>connect.execute sql,,128

  4. #4
    Heaven's Martini Guest

    Default a bit generous today

    &nbsp;<BR>Update ItsmYbirthday Set giftsreceivedtoday=0 where product=&#039;Hooker&#039;<BR><BR><BR>j/k (but that should give you an idea.)

  5. #5
    Join Date
    Dec 1969

    Default RE: SQL doubt

    Hi, <BR><BR>Try looking at this link and learn how to use the SQL update procedure. If you are still having problems, just write back and either I or somebody else will answer more questions. <BR><BR>http://www.w3schools.com/sql/sql_update.asp<BR><BR>Hope this helps,<BR><BR>Vadim C.

Posting Permissions

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