Can you make this cursor updatable by adding READWRITE to the SQL? Or create cursor using create cursor command and append from the result of Select-SQl?
>Nadya
>Great call,dding the alias. to the field id worked!!. Thanks so much. One problem however: the problem persists if the alias is a cursor file created using sql within a stored procedure
>
>
>SELECT *;
> from PoItems;
> where ALLTRIM(PoItems.PoNum) == ALLTRIM(currentPoNum);
> INTO CURSOR tmpCsrPoMastItems nofilter
>
>Using tmpCsrPoMastItems as an alias yields the same problem. Have any ideas??
>Thanks again, Vince
If it's not broken, fix it until it is.
My Blog