>>Hi,
>>
>>When attempting to preview a report a customer is getting error:
>>
>>
>>Cannot update the cursor E, since it is read-only
>>
>>
>>The E in the message does not have a colon; but could it be still pointing to a letter drive?
>>
>>TIA.
>
>I have found that the problem occurs when I try to add records from one cursor to another. That is, first the program gets records from a table (in SQL Server database) into a cursor. Then another cursor is filled from another SQL Server table. Then I try to append one cursor to another using the following code:
>
>
>select (cCursor1)
>append from dbf("cCursor2")
>
>
>The application gives error on the APPEND FROM .. line above. What am I doing wrong? TIA.
Try using
insert into cCursor1 (...)
select ... from cCursor2
cCursor1 must be read-write cursor for this to work.
If it's not broken, fix it until it is.
My Blog