add and modify


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: add and modify

Hybrid View

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    add and modify

    [Originally posted by c isaac]

    To add and modify a MsAccess table through VB

    To find the max value in a field in a table

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:add and modify

    [Originally posted by Tich]

    what are you using? DAO or ADO?

    You can create tables using ADO, by generating the SQL to create the table (whats in the SQL depends on the database), and callnig the 'Execute' method

    the SQL for getting the max value will be something like
    SELECT max(column_name) FROM table_name

    and you can always add a 'where' clause on the end to restrict the search.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center