Any help on the attached errors would be helpful. I'm deploying a database that was imported from VFP 9 and then manually tweaked by me to be suitable for my SQL server. When I deploy, I get errors on the 3 tables circled. Of course those errors cause those 3 table deployments to fail.



(.gif attached)

Remember, You Can Pick Your Friends

You Can Pick Your Nose But

You Can't Pick Your Friend's Nose

The first 2 are most likely being caused by an invalid default value constraint on a field within those tables.  The default value must be wrapped in parenthesis like this: (''), not just plain like this: ''  As for the 3rd error, it looks like one of the fieldnames is blank... it should not have imported if the field was blank, but you might check the table for strange values within the default values as well.

Ben,



Thanks for the input. I will look into your solution this morning.



Ed

Remember, You Can Pick Your Friends

You Can Pick Your Nose But

You Can't Pick Your Friend's Nose

Let me know what you find

Thanks