var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: HELP!!! Need to add a number col remotely
I'm in a big bind and appreciate an answer as soon as possible. I've used one dbase to update another to add a column - I added a char column using
alter table add fieldname char(50)
my mind has shut down as to how I can make that an number, integer???
I believe the syntax is: alter table add fieldname integer
Ok I can add a number, but how do I change it to be an Integer?
Thanks, it adds it but it makes it a long integer... how can I make it be just an integer -- and thank you so much for posting so quickly - people are breathing down my neck.
alter table add column integer
and the table is added as a Number
BUT NOW how can I change Field SIZE to Integer -- it is coming up Long Integer and that won't work in the app we are using.
IT IS FIXED !!! I had to identify it as a 'smallint'
(it's always the little things in life).....