| T O P I C R E V I E W |
| JJenson |
Posted - 30 September 2007 : 16:23:56
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  < |
| 8 L A T E S T R E P L I E S (Newest First) |
| JJenson |
Posted - 01 October 2007 : 12:20:56
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.< |
| HuwR |
Posted - 01 October 2007 : 12:19:16
there should be a readme around somewhere that explains how to use them< |
| JJenson |
Posted - 01 October 2007 : 09:26:10
oh ok I think I understand DBS scripts confuse me a bit still after reading your post on them. But thanks < |
| HuwR |
Posted - 01 October 2007 : 02:06:26
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< |
| JJenson |
Posted - 30 September 2007 : 17:50:56
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?
< |
| JJenson |
Posted - 30 September 2007 : 17:41:22
wait its varchar(20) correct?< |
| JJenson |
Posted - 30 September 2007 : 17:30:48
not sure what I should put in there somethingl ike var(21)?< |
| HuwR |
Posted - 30 September 2007 : 17:24:27
almost, except 0.00 is not an int < |
