Insert/Update on the same form

[TMR]

Yes, you only need one form then in the Server Connect you find out if it needs to update or insert.

In the form I have a hidden field that has the ID of the data being manipulated from the Server Connect. If server side detects an ID it means a record already exists, so the DB is updated, otherwise an insert is carried out.

On the front end, populate the form with the record info that is required. If there are no DB records for it the fields will be blank anyway.

This should help:

Update or insert in an action

Yes, that’s how most of us are probably doing it now ben but the upsert i refer to would be a single action SQL allows for a statement such as: INSERT INTO tab1 (col1, col2, col3) VALUES (10,20,30) ON DUPLICATE KEY UPDATE col3=col3+1; the insert is first tried but if there is a key violation the update runs in it’s place It would be nice to be able to do this within a new UPSERT action where the insert and update could be defined within 1 query action