Member Avatar for gerchi152

I want to delete selected column values only... I have this statement:

strsql = "delete book1, author1, from book_Load where Book_ID_no = '" & bkIDnum.Text & "'"
With sqlcmd
            .CommandText = strsql
            .Connection = sqlconn
            .ExecuteNonQuery()
        End With

the error is "Incorrect syntax near ','."
please help me with this... thanks

  • 3 Contributors
  • 3 Replies
  • 75 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for hericles

Remove the comma after author1. It should read:

strsql = "delete book1, author1 from book_Load where Book_ID_no = '" & bkIDnum.Text & "'"
Member Avatar for gerchi152

I've already did that but the error is still the same

Member Avatar for M.Waqas Aslam

you can not delete single column value , you have to delete full record , if you want to delete value of single column then try to use update , just update the value with null .

Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.