saving a rst to a db

[Ralph Carrasquillo]

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.

[Brent]

"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