Francis Boundy
|
| Posted: 08/13/2001, 12:08 PM |
|
OK - another dumb Newbie question:
How do I autoincrement a Primary Key on Insert? Obviously I need an Before
Insert event on the form but I can't figure out what to enter.
TIA
Francis Boundy
|
|
|
 |
Don Oldenburg
|
| Posted: 08/13/2001, 12:51 PM |
|
Francis
I use SQL... and I have my database setup to do that automatically by
setting the type to INT, and turning off the "allow nulls" option, and
checking the "identity" option. This will auto populate "identity seed=1"
and "identity increment=1" automatically.
I don't believe you want your program to have to deal with this -- leaves
way to many potential problems the ability to surface.
Hope that helps...
Don
"Francis Boundy" <fboundy@troyikoda.com> wrote in message
news:9l98in$dvi$1@news.codecharge.com...
> OK - another dumb Newbie question:
>
> How do I autoincrement a Primary Key on Insert? Obviously I need an Before
> Insert event on the form but I can't figure out what to enter.
>
> TIA
>
> Francis Boundy
>
>
>
>
|
|
|
|
|
