>>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,
Good catch!
If it's not broken, fix it until it is.
My Blog