ALTER TABLE mycursor ...
NB! You must make sure that the cursor is not read only, for example
SELECT whatever FROM yourtable INTO CURSOR yourcursor READWRITE>Is there any way to modify the structure of a cursor? I'm selecting rows from a MS-SQL table into a cursor. There are nearly forty columns in the resulting cursor. Two of the columns are text columns that I have to break down into four columns of fifty chars each. I do this with the MLINE() function to fill in the four new columns that I preallocated in the SQL SELECT...statement. I need to manipulate each of the fifty char columnns before I export the cursor to a SDF format file on another platform. But before I export and create the file I need to drop the two original text fields from the cursor. When I tried to do this I got an error saying that the SQL ALTER TABLE command was not valid for a cursor. Is there any way to do this without naming all of the columns I want in a second SQL SELECT command?
>
>Jim White