sqlobject-discuss

[SQLObject] Unable to set StringCol to be UNIQUE

[luis c. <lo....@gm...>]

Keeps throwing an error in MS SQL Server that this column type is not
capable of being made a key ... is it possible to make this a unique field
in SQL Server?  My code is simple:

class myClass(SQLObject):
    fld_name = StringCol(alternateID=True, unique=True)

Please help.

- Luis

Re: [SQLObject] Unable to set StringCol to be UNIQUE

[Imri G. <lor...@gm...>]

Heya
Top of my head:
Try also setting length = 90 or some lower number (perhaps start with 80).

cheers,
Imri

On Tue, Aug 10, 2010 at 6:29 PM, luis cota <lo....@gm...> wrote:

> Keeps throwing an error in MS SQL Server that this column type is not
> capable of being made a key ... is it possible to make this a unique field
> in SQL Server?  My code is simple:
>
> class myClass(SQLObject):
>     fld_name = StringCol(alternateID=True, unique=True)
>
> Please help.
>
> - Luis
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
>


-- 
Imri Goldberg
--------------------------------------
http://plnnr.com/ - automatic trip planning
http://www.algorithm.co.il/blogs/
--------------------------------------
-- insert signature here ----