Member Avatar for bestex

Hi why do i have errors in updating a column using where? this is my code

"Update inventory Set isExpired='1' from  inventory where expirationDate= '" & DateTimePicker1.Text & "'"

my date format is yyy-MM-dd can anyone help me pls?

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Pgmer
Member Avatar for Pgmer

which DB you are using?
check your update statement.
In sql it is like
update Tablename set columnname=yourvalue where condition

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.