Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access Autonumber

 
V Srinivasan
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In Access Autonumber has been defined as LongInteger. I want to assign this Autonumber in a field in my application. I failed to assign it in int, long, String. Any clue how can I store this autonumber. Basically I want to use it for future call of query.
Please help me.
Thanks
V. Srinivasan
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure I understand your problem so I'll give you 2 examples:
emp table has the following columns:
id: autonumber
emp_fname: String
emp_lname: String
hiredate: date
INSERT:

SELECT:

is this what you were asking?
Jamie
[This message has been edited by Jamie Robertson (edited November 12, 2001).]
 
V Srinivasan
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jamie,
Thank you very much for your response, I found the problem.
Thanks
[This message has been edited by V Srinivasan (edited November 13, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic