If I understand you right, you are probably going to need two queries. One to UPDATE the records already in the table and then a second to insert the records not currently in the table.
I just wanted to know if there was some way to do a replace query so I didn't have to do a write and then an update. I just thought I remembered that some databases accepted "INSERT INTO REPLACING" or "REPLACE INTO" or something like that.
i tried the replace and substitute functions in an update's and append's criteria row. now i'm writing an expression based on iif.
- which didn't work.
where would the replace function be written? not the criteria row.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.