Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing data error
Message
 
To
20/07/1998 21:03:16
Rick Clarke
Fotobae Pty. Ltd.
Adelaide, Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00119535
Message ID:
00119541
Views:
18
>Hi Fellow Fox Developers,
>
>I am having trouble importing to a table that I used COPY STRU to create. both tables are identical. I can import to the second table ok but I can't append from or use replace to copy new imports to the original table. I get invalid data error. e.g incombatible data types.
>I have thouroughly checked the tables and both have same indexes names and data types. can I fix this or is it a bug?
>TIA

Rick,

Try doing it wiht one field per REPLACE command so you can find out which fields is bombing out on you. Then check teh data as well as the structure of the two tables. You may have NULLs in one and the other doesn't allow NULL in that field.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform