>I have two cursors that are both READWRITE. However, one will allow an ALTER TABLE and the other will not. In the Data Session I can see where the first cursor will let me click on Properties and the second will not. But why??
>
>This Works
>
>SELECT obligor, obligation FROM obligat_cur ;
> ORDER BY obligor, obligation ;
> INTO CURSOR obligat READWRITE ;
> group by obligor, obligation
>
>ALTER table obligat add COLUMN unit c(5)
>
>
>This gets an Invalid Operation for the Cursor on the ALTER.
>
>SELECT obligor as obligor, a.site_id as site_id, b.* ;
> FROM obligor1 as a, cadirectry as b ;
> INTO CURSOR obligor READWRITE
>
>ALTER table obligor add COLUMN name c(10)
Part of the problem may be that the second cursor is pulled from 2 tables but there is no join condition.
Regards,
Jim