>Hi All,
>
>Strange problem with a VFP6 Sp5 program. The program adds data from a free table to a DBC based table (unbuffered). Its a simple one-to-one correspondence. The source table is scattered, basic checks are performed, NULLS are converted to the appropriate types, then using INSERT INTO MyTable FROM MEMVAR records are added to the DBC table. Simple.
>
>Except at the insert I get a Data Type Mismatch error. The strange thing is: The record that errored is added to the DBC based table despite the type mismatch.
>
>Has anyone seen this behavior?
>
I've seen this happens when the table you INSERT into has some fields w/o corresponded memory variables. To fix it
Select mydbctable
SCATTER MEMVAR BLANK MEMO
....
--sb--