Re: Ado, Transaction, Multiline statements?

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/25/05 

Date: Mon, 24 Jan 2005 21:10:14 -0600

>Follow up question:
>Is there a better way to do this type of master-detail insert? Should I
>look into something like a ClientDataset and then batch the update bact to
>the server, or is my 'stacked' insert string just as good?

You are probably doing a lot of work in your code for a small return on speed.
That may be worth it to you but there are probably easier ways to develop the
application
Also if you have a large enough number of detail records you might run into a
limit on the size of an SQL statement at some time.

It is also not clear to me why you have 20-30 detail records to insert. If you
are allowing a user to enter information for these records you probably would be
better using dataware controls that use BatchUpdate. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com