>I have an application build that starts with this code
>Close data all
>Close tables all
>Use tableids again in 0
>select tableids
>replace tableid with tableid+1 in tableids
>
>When trying to replace I get the error
>Cannot update cursor
>
>But when running not compiled its running ok I get this error only when running .app or exe
>
>Can anyone please help?
>
>ThanxThat error generally indicates that you have placed ('included') the table into your exe (or app). Go to the tables section of the project window and make sure you mark the tables as 'excluded').
In your code sample, if you just closed all tables, you do not need to use again in 0, just
USE tableids
should do. When you
Select
and
Replace
, you have to make sure you have records. Your
Replace
line would fail of the table was at
eof()
with either no records or
Set Deleted On
and only deleted records.
HTH