INSERT

From: Darren (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 07:14:08 -0800

I have ten tables. There is an ASP web front end. This
is a work order and each table represents a page of the
work order.

They fill out the first form which is all of the customer
info. There is an identity field that autoincrements the
work order number.

When they are done filling this form they go to a page
with links to the other pages. I need to be able to pull
the identity column parameter for that workorder to use
as a link to the other pages.

I can get this to work if I manually enter the work order
number on the first page, because the wo_number is in the
INSERT statement.

Is there a way to INSERT the wo_number field in the
statement and auto-increment it with code instead of
using the identity field?

Any help or suggestions would be appreciated.

Thanks,
Darren

Relevant Pages

  • Re: copying rows
    ... col1 INT NOT NULL PRIMARY KEY, ... > submitted it creates a record that has an identity field in the maintable. ... The user then submits an asp form for each table ... > the user wants to enter more that one work order that is exactly the same. ...
    (microsoft.public.sqlserver.programming)
  • copying rows
    ... I have a work order system with 6 tables. ... When the first asp form is ... submitted it creates a record that has an identity field in the maintable. ... The user then submits an asp form for each table ...
    (microsoft.public.sqlserver.programming)