StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



DDT Deploy errorExpand / Collapse
Author
Message
Posted 09/11/2006 3:05:56 PM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame 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


  Post Attachments 
ddt_error1.gif (43 views, 37.07 KB)
Post #2740
Posted 09/11/2006 3:09:09 PM


StrataFrame Developer

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
Post #2741
Posted 09/12/2006 7:31:55 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame 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
Post #2745
Posted 09/12/2006 8:11:10 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890
Let me know what you find

Thanks


www.bungie.net
Post #2748
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 2:21am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 11 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.