•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 391,588 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,634 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 604 | Replies: 1
 |
•
•
Join Date: May 2006
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi All,
I got a question regarding sql.
I got some data in a ms access.
There's 3 columns, namely id, name and address. Here's an example.
And, I need to insert a row between 1 and 2. And, the id for 2 to 100 should increment by 1. Is there a sql statment which can do that?
Thanks alot.
I have been searching google for the past few days and I couldn't get the keyword correct.
I got a question regarding sql.
I got some data in a ms access.
There's 3 columns, namely id, name and address. Here's an example.
id name address 1 a c 2 c d 3 d e . . . . 100
And, I need to insert a row between 1 and 2. And, the id for 2 to 100 should increment by 1. Is there a sql statment which can do that?
Thanks alot.
I have been searching google for the past few days and I couldn't get the keyword correct.
•
•
Join Date: Jan 2007
Posts: 2,510
Reputation:
Rep Power: 7
Solved Threads: 103
SQL usually does not do that. It wants to keep the same ID for the same record in perpetuity.
The easiest way would be to delete the numbered column, then add it again as an autonumbering field. But it must not be the field the data is sorted on, and it must not be a primary key.
The easiest way would be to delete the numbered column, then add it again as an autonumbering field. But it must not be the field the data is sorted on, and it must not be a primary key.
Last edited by MidiMagic : Jun 19th, 2008 at 2:28 pm.
Daylight-saving time uses more gasoline
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
Similar Threads
- How to auto increment? (ASP.NET)
- overloading increment/decrement operators (C++)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Approval Process for Microsoft Access
- Next Thread: Email Validation Rule with MS ACCESS
