| | | 
StrataFrame Beginner
       
Group: StrataFrame Users Last Login: 09/17/2008 8:43:45 AM Posts: 13, Visits: 409 |
| 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
|
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: 12/02/2008 4:42:46 PM Posts: 2,686, Visits: 1,890 |
| 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.
www.bungie.net |
| | | | 
StrataFrame Beginner
       
Group: StrataFrame Users Last Login: 09/17/2008 8:43:45 AM Posts: 13, Visits: 409 |
| 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 |
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: 12/02/2008 4:42:46 PM Posts: 2,686, Visits: 1,890 |
| | |
|
|