Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Altering tables
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 November 2001 :  22:06:25  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I want to add columns to the table that holds the info for the mod center, but I want to do so without destroying the data that is already there. BUT, I dont know how, as I've been spoiled by using Huwr's mod_dbsetup.asp for altering tables :)

This is what I have, and its not working, help?

strsql = "ALTER TABLE SNITZ_MODS ADD COLUMN {DESCRIPTION TEXT}"

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 07 November 2001 :  22:38:55  Show Profile
This is an example from the Private Messages MOD older Database setup file:

strSql = "ALTER TABLE " & strMemberTablePrefix & "MEMBERS ADD M_PMEMAIL int DEFAULT 0 NULL;"

or how it would be processed:

strSql = "ALTER TABLE FORUM_MEMBERS ADD M_PMEMAIL int DEFAULT 0 NULL;"
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 November 2001 :  22:44:00  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Thx richard :)

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07