I have a database with Id (auto_increment), Songtitle, Genre and Songtext.
The app that I created uses 2 ADOQueries, 1 master and the other just to copy temporary records to it from the master.
When I try this, but clicking a button, I get the message Field 'Id' can't be modified.
I use the field Id for numbers, because of its auto_increment (can't be used twice in the same table, otherwise I would use number).
Is there a solution for this?