12.3.6 Oops

Yes, I forgot the column PASSWORD completely. It is easy enough to add it with the following statement:

ALTER TABLE members ADD COLUMN PASSWORD 
  CHAR(20) NOT NULL AFTER NICKNAME\g

This should work in most cases. However, the accounts set up on the Power server does not allow ALTER TABLE operations. As a result, you will receive an error message instead.

If you need to make changes to tables, please let me know so I can change your access rights.



Copyright © 2008-05-09 by Tak Auyeung