asked on
how can i add one field to my table?
I am using ADO to manipulate my table. i have an input table, then i will output several different tables, for the output table, how can i add an auto-increased ID field into my table? THANK YOU VERY MUCH FOR YOUR SUGGESTION :)
Programming
Last Comment
FaithRaven
in table design set property of column to autonumber
Its simple just make that column as autonumber and when u insert record use UPDATE query with out inserting any value for that column.
Please specify further your requirements.
1) What database
2) Are you using ADO to actually create the table, or to return the data from an already-defined table
3) What are the restrictions on the auto-increased ID field (is it OK to have gaps in the numbers?)
1) What database
2) Are you using ADO to actually create the table, or to return the data from an already-defined table
3) What are the restrictions on the auto-increased ID field (is it OK to have gaps in the numbers?)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
i use microsoft access to sort my database.
in fact, i am not going to create a table, i am using SQL to select certain records to my new table. so in one form, i use Microsoft Hierarchical FlexGrid Control to show one table, in the new form, i also use the same format, but i wanna add a new field named "S/N" so that i can know that how many records i have for the new table. thank you for you all's help...
in fact, i am not going to create a table, i am using SQL to select certain records to my new table. so in one form, i use Microsoft Hierarchical FlexGrid Control to show one table, in the new form, i also use the same format, but i wanna add a new field named "S/N" so that i can know that how many records i have for the new table. thank you for you all's help...
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept twalgrave's comment
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
FaithRaven
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Accept twalgrave's comment
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
FaithRaven
EE Cleanup Volunteer