>>>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.
The customer claims that this worked before and now stopped working. Is it at all possible that the syntax APPEND FROM (as I have) could work?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham