Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
INSERT and UPDATE Usage
Environment versions
Network:
Windows 2008 Server
I have a scenario where I need to INSERT into a table, but only if the record does not already exist. If it does exist, then I want to UPDATE it. There are a couple key fields that I can use to do the matching. I have a table open in the current workarea, and some of the values from the current record are what get inserted/updated in the 2nd table that is open. What would be the best way to handle that?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only