PDA

Click to See Complete Forum and Search --> : 2 ASP questions


Bios
Feb 17th, 2001, 08:48 AM
1.) In an access database I know how to add a row, but how do you add a new column to a table in the database?

2.) I know a little about Scripting.FileSystemObject, but am just now using it for the first time. I know how to use createtextfile to write to a text file, and opentextfile to read to a text file...I was wondering if opentextfile can be used to write to the end of the file. Also if there is a way to remove a line from a file with out reading each line into an array then writting it again... any input about reading and writing a text file would be helpful.


:D Thank you for any help in advance,

Feb 21st, 2001, 10:54 AM
i just have the answer for your first question;

for example

ALTER TABLE ANTIQUES ADD (PRICE DECIMAL(8,2) NULL);

good luck