Posts: 51 Joined: 6/17/2002 From: United Kingdom Status: offline
A silly question I am sure - 4/29/2003 8:50:04
Hey guys sorry about asking this basic question i' m sure.
I can' t test anything today due to server issues.
All I am trying to do is save info from a form to a database that is already created and then use the vb front end off line later. Simple I know but my question is does the primary key autonumber get updated automatically or do I have to add a hidden field to add a key to this field?
I am sorry to waste your time but I can' t test it yet to figure it out my self.
amj123123
Posts: 51 Joined: 6/17/2002 From: United Kingdom Status: offline
RE: A silly question I am sure - 4/29/2003 8:50:45
sorry
RE: A silly question I am sure - 4/29/2003 11:43:45
Autonumbers are incremented in the database itself. Don' t include the autonumber field in an update or insert statement.