This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Allow new records only

Posted on 01-27-2020 10:10 AM
Mynor_Menendez
New Member
Reply posted on --/--/---- --:-- AM

Hi. I would like to know if there is a way to allow only the insertion of new records in a column

Solved Solved
0 13 523
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
LeventK
Silver 5
Silver 5
In response to Mynor_Menendez
Reply posted on --/--/---- --:-- AM

@Mynor_Menendez
Can you try with this?

SELECT(RefTableName[KeyColumn],TRUE) - SELECT(RefTableName[KeyColumn],TRUE) + SELECT(RefTableName[KeyColumn],[_RowNumber]=MAX(SELECT(RefTableName[_RowNumber],TRUE)))

View solution in original post

Jump to Solution
13 REPLIES 13
Top Labels in this Space