>>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
>
>Hi Cetin,
> Unfortunately, what i mentioned happenedly is for SPT cursor.the fields of cursor are dynamically generated at side of SQL Server,in which there is a redundant column as relationship field,couldn't be removed at side of SQL.
>Thus i want to remove it at VFP client.Any further ideas on conveting a SPT cursor into a general cursor? Certainly, it can be clone as real dbf then generate another cursor,but i don't like this way.:)
Why you can't remove on SQL side? Even if you can't why there is a need to remove?
CetinÇetin Basöz
The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses
LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
