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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL