Updating or Insert Into has me confused

[Alfarata]

On a forms first use how do I know If I'm Inserting Into Or Updating the first use? I know there is an easy answer to this but its evading me.

Thanks

[FunkyDexter]

I'm not sure I follow you. Are you saying you want to update a record if it exists? Otherwise Insert it? If so there are basically three ways of doing it:-
1. Issue a select statement for the record and either update or insert based on whether you get a result.
2. Issue an Update then check if any records were affected (e.g. by checking @@Rowcount). If no rows were affected issue an Insert.
3. Use an Upsert. Different databases have different Syntaxes for this. SQL Server's, for example, is the merge Statement.

Or are you saying you want to know if you application form is in "Insert" or "Update" mode? In which case you need to track that yourself in the application. We'd need to know a lot more about your application before we could make any suggestions for this.

Or are you asking something else?

[Alfarata]

I BELIEVE THIS IS MY ANSWER
# 2. Issue an Update then check if any records were affected (e.g. by checking @@Rowcount). If no rows were affected issue an Insert.

THANKS

[szlamany]

Yes - that is a valid technique

Update AWCUserSalt_T Set PasswordSalt=@PasswordSalt Where UserId=@UserId
If @@RowCount=0 Insert into AWCUserSalt_T values (@UserId, @PasswordSalt, GetDate())