More SQL Questions

Greg Keys ( (no email) )
Fri, 5 Jun 1998 14:11:29 -0400

Well, as long as I am asking simpleminded questions and people are taking
pity on my feeble state....... here is another one....
I just added the CallDetails table and appropriate trigger as per info from
Dale.
As I watch Radius I see an occasional failure to update the calls online
data via the trigger. It seems, after a little study, that the CallDetail
table has 18 characters for the username whilst the rest of the tables
support 32. I have one user who has 19 characters in there username.
Is there any way to modify the size of a item in a table without dropping
the table and recreating it?
I know I can write a table that creates another table, copies the data,
drops the original table, create the table again and copy the data back, but
I am hoping for more simple solution.....

Gregory E. Keys
System Administrator
LoclNet (A Division of ESC Inc.)
Electro-data Systems Company Inc.
Voice: (704)861-1251
Fax: (704)861-1870
E-Mail: greg@loclnet.com