>Dear all,
>
>I am getting a "Data type mismatch" (VFP error 9) on the following repro code, which is quite simple and self-describing (I hope). Can any one be so kind to point out the problem and/or a solution? This code runs in VFP8 SP1.
>
>Thanks in advance.
>
>Cheers
>
>* =================
>* repro code, VFP error 9 - what's wrong here?
>LOCAL lcTable
>LOCAL loEx
>
>SET AUTOINCERROR OFF
>CLOSE TABLES ALL
>
>* create a temporary table, with only 2 fields (one of them is autoinc!)
>lcTable = 'temp_oct13'
>CREATE TABLE (lcTable) (c1 c(10), c2 i AUTOINC)
>
>* and a candidate index, with an "for !deleted()" filter
>INDEX ON c1 TAG c1 CANDIDATE FOR !DELETED()
>
>USE (lcTable) SHARED && must be "shared" to see the error
>CURSORSETPROP('buffering', 5) && optimistic table buffering
>
>SCATTER MEMVAR && on an empty record (doesn't matter in this case)
>APPEND BLANK && so far so good
>
>TRY
> ** RELEASE m.c2 && you guessed it: if you uncomment this line it then works
> && unfortunately that's not exactly what I want
>
> * otherwise you get the "data type mismatch" error here, why???
> GATHER MEMVAR
>
> MESSAGEBOX('It worked', 0, 'Cool', 2000)
>CATCH TO loEx
> MESSAGEBOX('SORRY, cannot "GATHER MEMVAR" here', 48, loEx.message)
>FINALLY
> DROP TABLE (lcTable)
>ENDTRY
>
>RETURN
>
>* end of repro code

C2 IS A READONLY FIELD

GATHER FIELDS EXCEPT C2 MEMVAR