This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm new to Lightspeed, so please forgive me if I'm doing something wrong. I have one table where I want to change the datatype of a column from Int32 to double. However, when I attempt to update the database, I get the following error: -- Change column Longitude from Int32 to Double ALTER TABLE [Site] ALTER COLUMN [Longitude] FLOAT NOT NULL;/* ERROR: Site: Change column Longitude from Int32 to Double - The object 'DF__Site__Longitude__014935CB' is dependent on column 'Longitude'.ALTER TABLE ALTER COLUMN Longitude failed because one or more objects access this column. */ ;This table is auto-generated from the graphical designer. What is this constraint for, and how can I get around this problem? Thanks. |
|
|
|
|
This is a SQL Server default value constraint. It arises because we provide a default when we create a column. Unfortunately, it seems we're not removing it before we try to alter or delete a column. There isn't a way around it right now: I'll take a look at this and try to get you a fix asap (we're a bit heads down at the moment so this may take a couple of days). Thanks for reporting the problem! |
|
|
|
|
There will be a fix for this in nightly builds dated 20 Oct 2009 and above, available from about 1430 GMT. Please let us know if you still see problems. |
|
|
|
