Snitz Forums 2000 - Help on dbs

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/O Code)

Help on dbs

New Topic

Topic Locked

Printer Friendly

Author

Topic

Chiz
Junior Member

245 Posts

Posted - 07 May 2002 : 23:23:03

Being new to MOD creation, I distributed my dbs file in the form of the following:


[CREATE]
CategorizedIconsCategories
CatId
CatOrderNum#Int##
CatName#VARCHAR(255)##
[END]

The dbs created the columns with the Required set to Yes. Now, I would like the Required property set to No.

Trying out a ALTER command with the following format won't set it to No.


[ALTER]
CategorizedIconsCategories
ALTER#CatOrderNum#Int#NULL#
ALTER#CatName#VARCHAR(255)#NULL#
[END]

This is with reference to this post.

I've read from some ASP discussion boards that having columns set to Required=Yes causes some weird errors and it seems that my MOD is suffering from the same.

Appreciate any help. Thanks.

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons

Edited by - Chiz on 07 May 2002 23:28:56

Chiz
Junior Member

245 Posts

Posted - 11 May 2002 : 01:07:32

*bump*

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 11 May 2002 : 01:30:27

I don't think that you can use ALTER to achieve what you are wanting. Probably best to drop the columns and then readd them (or just drop the whole table and then readd it).

Chiz
Junior Member

245 Posts

Posted - 11 May 2002 : 02:01:08

Thanks, Richard.

Since you already confirmed that it is not possible via the ALTER dbs command, I might do it through .asp file that will modify the table via SQL command.

I can't drop the table coz for sure there are new records there already.

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.25 seconds.