Tom,
I am not completely sure about it, but Insert into is standard SQL and with append I am not sure about it. I love to use append when working with R prompt, but it seems to me you are more in control using Insert into in an application. I agree append is flexible when it comes to adding colums to a table. But as always: all advantages have their disadvantages (as a Dutch football legend Johan Cruyff once said) Using Find in Forms, Reports, Files you are able to track down where the Insert into is being used in your application. So in the end I would prefer using Insert into. Tony From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: zondag 13 april 2014 17:51 To: RBASE-L Mailing List Subject: [RBASE-L] - Append vs Insert I used append many years ago, then went to insert, and want to know which is the preferred way? The reason I ask is because I have from time to time added a new column to a table and forgot to change the insert to reflect the change. eg: project temptable from inventorytable using all where limit=0 add my data to temptable insert temptable into salestable My thought process is that if append is used I would not have to worry about changing my insert Tom Hart
