The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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
<
[ALTER]
FILEMANAGER
ADD#F_AMOUNT#int#NULL#0.00
[END]
Thanks
نوشته شده در
almost, except 0.00 is not an int
<
نوشته شده در
not sure what I should put in there somethingl ike var(21)?<
نوشته شده در
wait its varchar(20) correct?<
نوشته شده در
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? <
[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? <
نوشته شده در
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<
ADD#F_AMOUNT#varchar(11)#NULL
or
ADD#F_AMOUNT#varchar(11)#0.00
not
ADD#F_AMOUNT#varchar(11)#NULL#0.00<
نوشته شده در
oh ok I think I understand DBS scripts confuse me a bit still after reading your post on them. But thanks
<
نوشته شده در
there should be a readme around somewhere that explains how to use them<
نوشته شده در
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.<
BUt that is good to have for future reference.<
Email Member
Message Member
Post Moderation
بارگزاری فایل
If you're having problems uploading, try choosing a smaller image.
پیشنمایش مطلب
Send Topic
Loading...