If this is a new record, then you must use INSERT.
If this is an existing record and you are changing a field from the primairy key, then you must use RENAME.
Keep It Simple and Stupid (KISS), but never oversimplify.
Unfortunately I am using a web-interface that does not return an exact error.
It is not a new record. I am modifying an existing record. I have created a new field which gets data from another field and I am trying to insert it in the record.
Comments
If this is an existing record and you are changing a field from the primairy key, then you must use RENAME.
Unfortunately I am using a web-interface that does not return an exact error.
It is not a new record. I am modifying an existing record. I have created a new field which gets data from another field and I am trying to insert it in the record.
Not sure why but it worked.