insert autonumber value

Question

0.00/5 (No votes)

See more:

how to insert value of field having autofield data type with access database..???
i need a insert query for this....!!!!

Example:-
i have table having two filed (no autonumber,name text)
now i want to take a input from use of name and autonumber do thier work automaticalyy then what will be the insert query ???

Posted 26-Jan-13 17:05pm

vihangshah

Updated 26-Jan-13 19:57pm

v2

Add a Solution

Comments

Sandeep Mewara 27-Jan-13 1:49am

Not clear. Please rephrase & Elaborate.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2013-01-26T22:50:00

Solution 1

Let's make clear:
A) you want to override the value that would be generated with a value coming from elsewhere?
Sorry, but you can't do that in access :(.

B) you want to make the number generation to work?
In this case you simply have to omit totally that field from the insert statement.

Posted 26-Jan-13 22:50pm

Zoltán Zörgő

Comments

vihangshah 27-Jan-13 23:29pm

ya B option is proper but when i omit that field then fire a exception .....!!!! now what to do ??/

Zoltán Zörgő 28-Jan-13 0:29am

If you issue a "select into" statement directly, you should not get any exception. But if you use other tools, where you populate field objects, you should care about specifying on c# side, that the "no" field is autonumber. But the exact way depends on what you are using, so please update your original question with the code sequence you are using to insert.

vihangshah 4-Feb-13 4:51am

i have table having two filed (no autonumber,name text)
now i want to take a input of name field from user and autonumber do their work by thier own so now tell mw the INSERT query which one i write on my coding page ???

Zoltán Zörgő 4-Feb-13 5:26am

I can't tell more, than I already have. If you use autonumber, you can not override it in an insert statement. That is a limitation in access.

fjdiewornncalwe 14-Mar-13 14:02pm

My 5.