saving a rst to a db


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: saving a rst to a db

Hybrid View

  1. #1
    Ralph Carrasquillo Guest

    saving a rst to a db


    Hi, I hope this is an easy one... Its an order entry app and what I'm doing
    is building the order and storing it in a MSFGrid (no saves yet to db). When
    the user saves the order the app I was thinking of extracting the data to
    a rst and then saving that to a db.
    My questions are...
    How do you do this?
    Do you set it up as a batchupdate and then insert one row at a time?
    Or is there a way to save the entire rst?
    Or do I even need this temporary rst that gets filled and then saved?

    I know syntactically how to do it I just dont know which is the most efficient
    or the most practiced way of saving a rst or group of data.

    thanks, Ralph C.

  2. #2
    Brent Guest

    Re: saving a rst to a db


    "Ralph Carrasquillo" <Ralph_Carrasquillo@ninewest.com> wrote:
    >
    >Hi, I hope this is an easy one... Its an order entry app and what I'm doing
    >is building the order and storing it in a MSFGrid (no saves yet to db).

    When
    >the user saves the order the app I was thinking of extracting the data to
    >a rst and then saving that to a db.
    >My questions are...
    >How do you do this?
    >Do you set it up as a batchupdate and then insert one row at a time?
    >Or is there a way to save the entire rst?
    >Or do I even need this temporary rst that gets filled and then saved?
    >
    >I know syntactically how to do it I just dont know which is the most efficient
    >or the most practiced way of saving a rst or group of data.
    >
    >thanks, Ralph C.


    Ralph,
    You could do it either way, but I would always recommend using a recordset
    to update the DB (recordset make it easier to trap errors).

    IMHO,
    Brent

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