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: SQL
Expertise: Beginner
May 29, 1997

Inserting and deleting rows in table (Jet 3.0)

Question:
How can I add a row (recordset) so it gets inserted where it belongs, in alphabetical order? I use Jet 3.0, and when I update my database (.mdb), rows are inserted at the end.

Also, how can I delete a current row in my table? By "current," I mean the one currently loaded by data control.

Answer:
I believe your question relates to Visual Basic and the Jet engine. Unfortunately, there is no way to insert a record with Visual Basic into any position other than the end.

You have two options:

  1. Re-fetch all the data in sorted order after each insert, or
  2. Switch to Oracle Power Objects, which has this functionality.
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