Re: increasing a field length in SQL

John C. Lange, Sr. ( (no email) )
Fri, 21 Feb 1997 10:39:56 -0600

Sooooory, I thought that it would work. I need to do the same with the
servername field, for my portmasters. Some of the names are 26 or more
characters long.

Josh Hillman wrote:
>
> Already tried it. When I double-click on the RadValues table and attempt
> to change the existing "25", the machine just beeps and doesn't allow you
> to alter the number in any way. Any other ideas?
>
> Thanks,
>
> Josh Hillman
> hillman@talstar.com
>
> > Use the SQL Enterprise Manager to make the change.
> >
> > JOhn :}
> >
> > Josh Hillman wrote:
> > >
> > > I need to increase a field length from 25 characters to about 30 or 35
> in
> > > SQL 6.5. What's the script to do that?
> > >
> > > The table is RadValues
> > > The field name is "Name"
> > >
> > > Thanks,
> > >
> > > Josh Hillman
> > > hillman@talstar.com
> > >
> > > -
> > > Emerald Mailing list (emerald@iea.com)
> >
> > --
> >
> > Emerald 2.0.75
> > Primary: Radius 1.16.49 -> DOS Prompt => Radius.exe -x15 -b -R1
> > NT Workstation 3.51 sp5
> > Secondary: Radius 1.16.49 -> DOS Prompt => Radius.exe -x15 -b -R1
> > NT Server 4.0 NFR no/sp
> > SQL 6.5.201 NFR
> > Intel P133 32MB ram
> > 3 - PM2e-30's
> > USR Sportster 33.6K
> >
> > JOhn :}
> >
> > ---------------------------------------------------
> > John C. Lange, Sr. PALACE dot NET, INC.
> > mailto:microjl@palacenet.net MICRO-TECH Computers!
> > http://www.palacenet.net/ 230 West Cook Street
> > 608.742.1601 & 6980 Portage, WI 53901
> > ---------------------------------------------------
> >

-- 

Emerald 2.0.75Primary: Radius 1.16.49 -> DOS Prompt => Radius.exe -x15 -b -R1NT Workstation 3.51 sp5Secondary: Radius 1.16.49 -> DOS Prompt => Radius.exe -x15 -b -R1NT Server 4.0 NFR no/spSQL 6.5.201 NFRIntel P133 32MB ram3 - PM2e-30'sUSR Sportster 33.6K

JOhn :}

---------------------------------------------------John C. Lange, Sr. PALACE dot NET, INC.mailto:microjl@palacenet.net MICRO-TECH Computers!http://www.palacenet.net/ 230 West Cook Street608.742.1601 & 6980 Portage, WI 53901---------------------------------------------------