Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data type mismatch.....
Message
From
08/02/2000 15:34:26
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00328857
Message ID:
00329129
Views:
24
>vfp 3.0
>
>Hello All,
>
>I have 2 database files, trying to copy info from fields
>of one dbf to another. Field names are different and
>using scatter memvar and then insert and replace in 2nd
>dbf file.
>
>field sizes are same, field types are the same, but still
>encountering this error. Any thoughts????
>
>Thanks and have a great day.
>
>Becky

Just before your insert command, list memo like * to junk.txt -- and then examine the data types in junk.txt to be sure that they match the destination table. I had a problem like this once because a variable was left over that was character and a field in the new table that was a date.

Good luck!
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform