creating new field

Results 1 to 2 of 2

Thread: creating new field

  1. #1
    Join Date
    Dec 1969

    Default creating new field

    Is it possible to add a field to a database using ASP? Could any one point me to the right place?<BR><BR>Thanks<BR><BR>Russ:)

  2. #2
    Neil Popham Guest

    Default RE: creating new field

    "ALTER TABLE Employees ADD COLUMN Salary CURRENCY"<BR><BR>will insert a new field &#039Salary&#039 in the table &#039Employees&#039 which is of type Currency<BR><BR>"ALTER TABLE Employees ADD COLUMN Notes TEXT(25)"<BR><BR>will insert a new field &#039Notes&#039 of type Text, 25 characters in length<BR><BR>please note: i got this from the MSAcess help files, tested it and it works via ASP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts