Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rb112978
Starting Member
11 Posts |
 Posted - 2004-12-15 : 22:21:45
|
| How do we handle autonumbers in VBNet?Do we include it in our Select Statements?if Yes: What happens when we update it?If No: How do we get the values Proud to be Pinoy |
|
|
jhermiz
3564 Posts |
Posted - 2004-12-16 : 13:15:52
|
| I'm sort of puzzled as to what you are asking for?If you need an autonumber like an ID your backend handles that (identity / key / auto increment ???). And if you need it you SELECT YourID..if you don't you exclude it from your select.Not sure why you are asking how to handle them. And if the field is a pk auto number you can't update it.Jon |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-22 : 01:41:00
|
is the autonumber an identity column or sp/application generated in the table?just use your usual select,if it's identity or pk then you can't update it, else if it was updated, then it will be reflectedor you need to rephrase your questions  --------------------keeping it simple... |
|
|
|
|
|
|
How do we handle autonumbers in VBNet?