Google 'oracle merge' Here is one result, I just glanced at it but I think it gives the idea.
http://www.dba-oracle.com/oracle_tips_rittman_merge.htm Sorry, but I have not had to work with Access with CFM for years now and this whole time have been referring to Oracle and probably should have said database type earlier. I did not even realize Access would let people write stored procedures and custom functions like I have been mentioning in a few of my emails. On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>My guess is I actually just wipe out what is in there and then > repopulate > > This is also my guess, I never heard of a MERGE query in SQL. > I have an 800 page book on SQL and the word MERGE is not even in the > index. > > This apprach is deadly for Access database for instance, because it > creates empty records > and the database will grow much faster. > > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
