Integration Points

Extending Corporate Data …

#43 Simple Grid bind error ‘These columns don’t currently have unique values’

leave a comment »

This is caused usually by untrimmed data – run an update on all selected rows with  =  ltrim(rtrim([field]))

Telerik’s comments on this :

http://www.telerik.com/help/aspnet/grid/grderrormessages.html

http://www.telerik.com/community/forums/aspnet/grid/21326-these-columns-don-t-currently-have-unique-values.aspx

UDF :

http://blog.sqlauthority.com/2008/10/09/sql-server-2008-trim-function-user-defined-function/

Advertisement

Written by dmgorman

October 11, 2010 at 3:51 pm

Posted in SQL

«
»

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Follow

Get every new post delivered to your Inbox.