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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 DBS Script		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JJenson
Advanced Member

USA
2121 Posts
Posted - 30 September 2007 :  16:23:56  Show Profile  Visit JJenson's Homepage  Reply with Quote
If I want to add a column in for an amount in this form 10.00 would this script be proper?

[ALTER]
FILEMANAGER
ADD#F_AMOUNT#int#NULL#0.00
[END]

Thanks <

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 30 September 2007 :  17:24:27  Show Profile  Visit HuwR's Homepage  Reply with Quote
almost, except 0.00 is not an int <
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts
Posted - 30 September 2007 :  17:30:48  Show Profile  Visit JJenson's Homepage  Reply with Quote
not sure what I should put in there somethingl ike var(21)?<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts
Posted - 30 September 2007 :  17:41:22  Show Profile  Visit JJenson's Homepage  Reply with Quote
wait its varchar(20) correct?<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts
Posted - 30 September 2007 :  17:50:56  Show Profile  Visit JJenson's Homepage  Reply with Quote
Ok I ran this script:

[ALTER]
FILEMANAGER
ADD#F_AMOUNT#varchar(11)#NULL#0.00
[END]

and it gave me this message:


[ALTER]
Database setup finished

But it was not added to the db where did I go wronge?
<
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 01 October 2007 :  02:06:26  Show Profile  Visit HuwR's Homepage  Reply with Quote
it should be just

ADD#F_AMOUNT#varchar(11)#NULL
or
ADD#F_AMOUNT#varchar(11)#0.00

not
ADD#F_AMOUNT#varchar(11)#NULL#0.00<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts
Posted - 01 October 2007 :  09:26:10  Show Profile  Visit JJenson's Homepage  Reply with Quote
oh ok I think I understand DBS scripts confuse me a bit still after reading your post on them. But thanks <
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 01 October 2007 :  12:19:16  Show Profile  Visit HuwR's Homepage  Reply with Quote
there should be a readme around somewhere that explains how to use them<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts
Posted - 01 October 2007 :  12:20:56  Show Profile  Visit JJenson's Homepage  Reply with Quote
I actually found a reply you made to someone on DBS scripts I have used that for reference just not sure what all the values mean yet. I had to google search on the definition of VARCHAR lol But I actually just went intot he DB and create the column that way and all is working

BUt that is good to have for future reference.<
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07