Link to home
Start Free TrialLog in
Avatar of delphiuser2009
delphiuser2009

asked on

Field Id can't be modified

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?
ASKER CERTIFIED SOLUTION
Avatar of FactorB
FactorB

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of delphiuser2009
delphiuser2009

ASKER

wow, thanks man, that worked.
I didnt think of that being so easy.
It is always easier when you try to find a solution for someone's problem,
it is much different when you try to do the same for yourself. :)

B.