Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringDBS Script

DBS Script

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/65664?pagenum=1
Printed on: 05 November 2025, 14:46

Topic

Author : JJenson
Subject : DBS Script
Posted : 30 September 2007, 16:23
Message :

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

Replies ...

Reply Author: HuwR
Replied on: 30 September 2007, 17:24
Message:

almost, except 0.00 is not an int

Reply Author: JJenson
Replied on: 30 September 2007, 17:30
Message:

not sure what I should put in there somethingl ike var(21)?<

Reply Author: JJenson
Replied on: 30 September 2007, 17:41
Message:

wait its varchar(20) correct?<

Reply Author: JJenson
Replied on: 30 September 2007, 17:50
Message:

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? <

Reply Author: HuwR
Replied on: 01 October 2007, 02:06
Message:

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<

Reply Author: JJenson
Replied on: 01 October 2007, 09:26
Message:

oh ok I think I understand DBS scripts confuse me a bit still after reading your post on them. But thanks

Reply Author: HuwR
Replied on: 01 October 2007, 12:19
Message:

there should be a readme around somewhere that explains how to use them<

Reply Author: JJenson
Replied on: 01 October 2007, 12:20
Message:

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.<