>>>>For several days I've been trying to find an easy way to dump my FoxPro table(s) onto our MS SQL Server programatically (without using the Upsizing Wizard). I was curious how the rest of the FoxPro community was doing this.
>>>>
>>>>APPEND FROM into a remote view didn't seem to work; only kept first 200 records. Please help!
>>>
>>>Gino,
>>>
>>>Are you sure that your VFP table doesn't have any data that breaks rules in the SQL Server Table? APPEND FROM should work fine.
>>>
>>
>>
>>Good point. I look into this. Still doesn't make sense why that would fail but the INSERT INTO for each records doesn't. It said ID cannot be null..well, there are no NULL ID's in my VFP table! A bit strange.
>>
>>Thnnk you!
>>- GM
>
>The NULL value error may be coming from SQL Server. It may be saying that you have not supplied a value for that column and it cannot be null. Make sure that the ID column is updateable (If it is a key field of the SQL Server primary key, by default the view marks these fields as not updateable. Make sure that all the fields of your view are updateable)
Some fields in SQLSERVER Cannot be empty like Visual Foxpro (DATETIME,...). So the
Empty is converted to NULL. So if those fields are contained in the primary key, there
will be an error. SO you can put a default value (in the remote view and SQL SERVER)
for all fields and be sure, when you insert the new record. There is no null values
in the primary key.
Previous
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