Updating SQL tables using ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Updating SQL tables using ADO

  1. #1
    James Koontz Guest

    Updating SQL tables using ADO


    What is the best practice for updating a SQL Server 7.0 tables. I want to
    do this using ADO objects and doing a batch update in a VB6 environment.
    My current company passes parameters into stored procedures to update the
    tables using VB 6. The dba claims this saves time by only having to give
    the users access to the stored procedures. I have middle-tier objects for
    the data access.
    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: Updating SQL tables using ADO


    I'm on their side--use SPs. It's easy to call SPs and for a litany of other
    reasons it makes abundant sense.

    bv

    "James Koontz" <james.koontz@mail.state.ky.us> wrote:
    >
    >What is the best practice for updating a SQL Server 7.0 tables. I want to
    >do this using ADO objects and doing a batch update in a VB6 environment.
    >My current company passes parameters into stored procedures to update the
    >tables using VB 6. The dba claims this saves time by only having to give
    >the users access to the stored procedures. I have middle-tier objects for
    >the data access.


    Share on Google+

  3. #3
    James Koontz Guest

    Re: Updating SQL tables using ADO





    "Bill Vaughn" <billva@microsoft.com> wrote:
    >
    >I'm on their side--use SPs. It's easy to call SPs and for a litany of other
    >reasons it makes abundant sense.
    >
    >bv
    >
    >"James Koontz" <james.koontz@mail.state.ky.us> wrote:
    >>
    >>What is the best practice for updating a SQL Server 7.0 tables. I want

    to
    >>do this using ADO objects and doing a batch update in a VB6 environment.
    >>My current company passes parameters into stored procedures to update the
    >>tables using VB 6. The dba claims this saves time by only having to give
    >>the users access to the stored procedures. I have middle-tier objects

    for
    >>the data access.

    >

    I am using a disconnected recordset in the user interface that contains the
    information to be updated , currently all I would have to do is set the active
    connection and perform a batch update and this will update the tables. Their
    way, I have to create parameters using the fields collection of the recordset.
    It just seems like an extra step to go through. I do value your opinion
    on this though.
    Share on Google+

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