🚀 go-pugleaf

"Clayton M. Arends" wrote:
> 
> Hello all,
> 
> I am interested in writing a query that would insert data into multiple
> records with one execute.  I am currently doing the this using multiple
> exec's and updating the parameters in a loop but for performance purposes I
> wanted to see if it would be faster to execute all at once.  The help for
> BDE SQL says that INSERT "Adds one or more new rows of data in a table."
> 

The more part is if you are using a select statment to fill out the values to
insert.  Doing it the way you are you can't write SQL that will insert the
multiple rows that way.  Do it row by row like you are right now.



-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Learning is finding out what you already know.  Doing is demonstrating that you
know it.  Teaching is reminding others that they know it as well as you.  We are
all leaners, doers, teachers.  (R Bach)