I ran the following script in FlameRobin.  Database is on a virtual machine in 
the cloud.  
 When I checked results after running the script, also checked them in 
FlameRobin, all the changes had taken place EXCEPT TBLTESTER.TESTERLOGIN.  It 
was still the old size.
 

 The script ran without error.  What could cause this?
 

 DROP  INDEX idx_SubscriberLogin_LoginPwd;
COMMIT;
 DROP INDEX IDX_TESTER_LOGIN;
COMMIT;
 DROP INDEX IDX_TESTER_PWD;
COMMIT
 ALTER TABLE TBLTESTER ALTER TESTERLOGIN TYPE Varchar(80);
COMMIT;
 ALTER TABLE TBLTESTER ALTER TESTERPWD TYPE Varchar(32);
COMMIT;
 ALTER TABLE TBLSUBSCRIBERLOGIN ALTER SUBSCRIBERLOGIN TYPE VARCHAR(80);
COMMIT;
 ALTER TABLE TBLSUBSCRIBERLOGIN ALTER SUBSCRIBERPWD TYPE VARCHAR(32);
COMMIT;
 CREATE ASC INDEX idx_SubscriberLogin_LoginPwd ON tblSubscriberLogin 
(SubscriberLogin, SubscriberPwd);
COMMIT;
 CREATE ASC INDEX idx_Tester_Pwd ON tblTester (TesterPwd);
COMMIT;
 CREATE UNIQUE ASC INDEX idx_Tester_Login ON tblTester (TesterLogin);
COMMIT;
 

 Dixon Epperson

Reply via email to