By Ed Summers - 9/11/2006
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)
|
By StrataFrame Team - 9/11/2006
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.
|
By Ed Summers - 9/12/2006
Ben,
Thanks for the input. I will look into your solution this morning.
Ed
|
By StrataFrame Team - 9/12/2006
Let me know what you find  Thanks
|