I am receiving the error "Data type mismatch" on a TABLEUPDATE. What I know to be true.

A). VFP 7.0 SP1 to VFP table attached to DBC. PHDBASE index on target table and on field CM_Desc.

1). No Stored procedure on table so that is not cause of problem.

2). Optimistic Row bufferening is absolotuly set.

3). The data types for all values are correct. The reason I know this is that I am inserting from memvars. All Memvars are being written to errorlog. Terminal Services does not allow clip board cut & paste to local window I cannot prove this here but I have checked on several error records.

4). Researched archives for some other problem but cannot find any possibility.

The code is

nPrevTableBuffering = CURSORGETPROP('BUFFERING', 'SP_CM')
CURSORSETPROP('BUFFERING', 3, 'SP_CM')

.....

INSERT INTO SP_CM (        ;
      CM_Code,             ;
      CM_Desc,             ;
      CM_Hosp,             ;
      UNIQUE               ;
   ) VALUES (              ;
      cCode,               ;
      cCM_Desc,            ;
      cProvider,           ;
      cNewId               ;
   )

lWrite = .T.      

.....

IF !TABLEUPDATE(2, .T., 'SP_CM', 'aErrorr')
*   ^errors here