Re: Ascend Filters w/Rad 2.2

Dale E. Reed Jr. ( (no email) )
Fri, 01 May 1998 12:06:48 -0700

Ronnie D. Franklin wrote:
>
> If you use Visual InterDev, SQL 6.5 and SP3 or greater you can resize
> a field without rebuilding the database.
>
> > Basically, you need to put entried in the RadConfigs or
> > RadATConfigs tables with the filter in the data field of the
> > respective table. You may run into an issue where the data field
> > is two small. With SQL Server, you may have to rebuild the table
> > to get a sufficiently sizex data field.

SQL Server fundamentally does NOT allow you to resize a field. Period.
If Interdev allows you to do it, its creating a new table and copying
the data, plus patching all your DRIs. Not a difficult thing, just
tedious. Trying to do this on a table like MasterAccounts would
prove to be very painful and possibly causing corrupt data in your
database if its bust during the time. Not something I care to do. :(

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com