On Tue, 28 Nov 2006, Isaac Raway wrote:
Use an index on the table with your key values and call "INSERT OR UPDATE INTO t(...) VALUES(...)" for all creation and update operations. Unless you're dealing with a tremendous amount of data per record this will be perfectly efficient.
Isaac, I totally forgot about that! I recall reading about it in Mike Owens' book, but could not find it when I went through it looking for a solution. Many thanks, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
