[wdvltalk] RE: Autonumber trigger
Yeah your reply about .addnew arrived just after I sent. The mail here sometimes dawdles. -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:45 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger I did figure it out. It wasn't that causing the problems. It was an oversight by me. Thanks for the help. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:42 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Fine set "prod_id" for "numeric" and then look at the bottom of the page in SQL EWnterprise Manager. Set "Identity" to "yes" (the default is "No"). That should set Identify Seed and Identity Increment each to 1. If you want to start at a different number than 1 or have a different increment, change one or both of those. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger I'm not sure I understand what you by setting an integer value for "id"? I have my auto column name set to proj_id and the data type is numeric. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in
[wdvltalk] RE: Autonumber trigger
I did figure it out. It wasn't that causing the problems. It was an oversight by me. Thanks for the help. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:42 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Fine set "prod_id" for "numeric" and then look at the bottom of the page in SQL EWnterprise Manager. Set "Identity" to "yes" (the default is "No"). That should set Identify Seed and Identity Increment each to 1. If you want to start at a different number than 1 or have a different increment, change one or both of those. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger I'm not sure I understand what you by setting an integer value for "id"? I have my auto column name set to proj_id and the data type is numeric. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscr
[wdvltalk] RE: Autonumber trigger
Fine set "prod_id" for "numeric" and then look at the bottom of the page in SQL EWnterprise Manager. Set "Identity" to "yes" (the default is "No"). That should set Identify Seed and Identity Increment each to 1. If you want to start at a different number than 1 or have a different increment, change one or both of those. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger I'm not sure I understand what you by setting an integer value for "id"? I have my auto column name set to proj_id and the data type is numeric. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto
[wdvltalk] RE: Autonumber trigger
I got it working. I didn't have .addnew in my submitting page. Thanks for all your help. Robert *-* Application Programmer x4863 -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:53 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger I'm not sure I understand what you by setting an integer value for "id"? I have my auto column name set to proj_id and the data type is numeric. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___
[wdvltalk] RE: Autonumber trigger
I'm not sure I understand what you by setting an integer value for "id"? I have my auto column name set to proj_id and the data type is numeric. Robert *-* Application Programmer x4863 -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Autonumber trigger Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Autonumber trigger
Either in the code creating the table by identifying the column as Auto, or by using the Enterprise Manager and setting an Integer value for "id" (the typical auto column name) and then setting the Identity as "Yes" and then under Columns at the bottom of the page as Identity. Identity Seed and Identity Increment should both set to 1. drew -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Autonumber trigger
What are you trying to do? Can you explain in brief. Thanks -Original Message- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: March 19, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Autonumber trigger How can I set an auto number trigger for SQL Server? Robert *-* Application Programmer x4863 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.