VB Databases BasicsBeginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
you could try running a delete query to remove the data
example:
strQueryDelete = "DELETE [columnName] FROM [tableName] WHERE [columnName]=" & txtCustID & ";"
then just run the query in code with a button click handler.
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
Albert Einstein
US (German-born) physicist (1879 - 1955)
As a DBA, I might also suggest using a procedure like an API that deletes the data-- that way you can code in some intellegence into the delete on the database side.
Just a thought.
The previous example would also work, of course. But you might have to check for dependant relationships (parent/child) etc that might cause errors.