Thats what I have been noticing over time and have mostly went to insert, but it does require fewer lines of code for append. Tom
________________________________ From: Gunnar Ekblad <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, April 13, 2009 10:45:48 AM Subject: [RBASE-L] - SV: Append vs insert Tom I am happy to use append It works fine within R:Base (the only db you really want to use) But if you are required to work with foreihg DB, then you better stick to INSERT, since that is working both with R:Base and foreign DB. I understand INSERT to be SQL standard and append to be R:BASE specific! If I create a new program I use insert but I am happy to keep my R:Base append code! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För TOM HART Skickat: den 13 april 2009 15:50 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Append vs insert I have followed the discussion in the past about append vs insert. I had always used append, but within the last year have converted all of my appends to insert and just want to know the pros and cons of which one to use. Most of my inserts use exact table structures ie same number of columns and names. Thanks, Tom Hart
