Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

Deleting a Record from the DBListBox

Question:
How do I delete a record with the data I've selected in a DBListBox (VB4.0). If I use the e.g. Findfirst command I get the message:
"The action was cancelled by an associated object."
Would it be possible to use "SelectedItem" or "Bookmark". If, then how?

Answer:
Since the DBListBox is the data source for the list, you can look at the Data.Recordset property, and use it like a Dynaset. For instance, if you wanted to delete the record from your box that had the word "Lego" from a field named "Name", you could do the following:

Data.Recordset.FindFirst "Name = 'Lego'"
Data.Recordset.Delete
That should work without any problems.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date