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
|
If I create a varchar(max) field in a DB table, then Update from Source, LightSpeed will let me put a Validate Length restriction on the field of longer than 4000 characters (which I need). However, if I create the field through the designer, it won't let me specify a length longer than 4000. Is there a way to get LightSpeed to create a DB schema with these long SQL Server character field types? |
|
|
|
|
This isn't currently possible. It will be supported in LightSpeed 3. I'll take a look at whether we can add something to the LightSpeed 2 nightly build to map lengths of >4000 to nvarchar(max) instead of an invalid nvarchar(some_large_number) type, and will let you know. |
|
|
|
|
There will be support for this in nightly builds dated 11 August 2009 and above, available from about 1430 GMT. If you have a length validation on a string field, and the maximum length is greater than 4000, LightSpeed will create a NVARCHAR(MAX) column. This feature is currently implemented only for SQL Server. Please let us know if you need it for any other database, or if you run into any problems. |
|
|
|
