General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Strange Behavior with Data Type Mismatch
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?
Thanks for your help
Robert
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only