Member Avatar for Agent-of-Chaos

i takes the current date value and then save it to text1.text

Text1.Text = Format(Now, "m/dd/yyyy")

then i am passing Text1.Text which actually contains date to Sql String which Delets all record that matches the Expiry date.. if current date = expiry date then delete that record..

strSQL = "DELETE * FROM Product WHERE Expiry_Date = '" & Text1.Text & "'"

but it gives error incorrect syntax near the keyword * and some time incorrect syntax near the keyword Delete

  • 3 Contributors
  • 3 Replies
  • 90 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Agent-of-Chaos
Member Avatar for jbisono

Take out the * and try it.

Member Avatar for debasisdas

* is not required in delete statement. use this

strSQL = "DELETE FROM Product WHERE Expiry_Date = '" & Text1.Text & "'"

Member Avatar for Agent-of-Chaos

Thanks Friends...this problem is solved ....... i have now one more problem see my new thread please please please.

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.