DBS Script - Postet den (1299 Views)
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
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 smile<
   
 Sidestørrelse 
Postet den
HuwR
Forum Admin
HuwR
Innlegg: 20611
20611
almost, except 0.00 is not an int smile<
Postet den
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
not sure what I should put in there somethingl ike var(21)?<
Postet den
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
wait its varchar(20) correct?<
Postet den
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
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? <
Postet den
HuwR
Forum Admin
HuwR
Innlegg: 20611
20611
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<
Postet den
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
oh ok I think I understand DBS scripts confuse me a bit still after reading your post on them. But thanks smile<
Postet den
HuwR
Forum Admin
HuwR
Innlegg: 20611
20611
there should be a readme around somewhere that explains how to use them<
Postet den
JJenson
Advanced Member
JJenson
Innlegg: 2121
2121
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 smile
BUt that is good to have for future reference.<
 
Du må legge inn en melding