The method is UpSert Your database has an object, stored procedure in SQLServer case, that receives all the parameters for a single row of data for that table.
The first thing you do is attempt an update of that row. If nothing is updated you then do an insert of those same params. I have been doing this practice for 1-2 years now and just heard the catchy name for it. I will also throw back the ID for the new record as an output param. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cajidmyj-7ggyptcmz_3f_w-5b5qjxvht2hertngi2r22hab...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
