>Hi Everybody,
> Learnt from error message that command Alter Table mycursorname Drop a_column_name is invaild to a cursor,but i sometimes do need so to do.

Aaron,
You can use 'alter table' with cursors.
Steven,
To be able to use 'alter table' you need a readwrite cursor, cursor should not be an SPT cursor and should not have any long field names in it. ie:

select * from customer into cursor myCursor readwrite
alter table myCursor ;
 drop column contact ;
 drop column title ;
 drop column address
browse

Cetin