?
Solved

Field Id can't be modified

Posted on 2009-07-15
3
Medium Priority
?
430 Views
Last Modified: 2013-11-23
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?
0
Comment
Question by:delphiuser2009
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
FactorB earned 200 total points
ID: 24863951
Nope, you shouldn't modify autoincrement field.
As the name says it increments by itself.
If you still want to modify it, try to change it in table 2 in type number or double...

Regards,
B.
0
 

Author Comment

by:delphiuser2009
ID: 24864101
wow, thanks man, that worked.
I didnt think of that being so easy.
0
 
LVL 6

Expert Comment

by:FactorB
ID: 24864609
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.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses
Course of the Month13 days, 2 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question