Subscribe to this thread
Home - General / All posts - Update query " Schema should contain at least one unique index."??
bdg63 post(s)
#25-May-17 15:42

I'm stuck on an update query.

Please help understand this error

Schema should contain at least one unique index.

in this query

code

UPDATE [Table]

SET [Zip3_int] = cast(StringSubstringLen(cast([GeoPostalCode] as varchar),0,3) as int32)

Dimitri


7,413 post(s)
#25-May-17 16:28

tables are not writable (includes updates, of course) if they don't have an index.

See http://manifold.net/doc/radian/index.htm#editing_tables.htm and http://manifold.net/doc/radian/index.htm#adding_an_index_to_a_table.htm and similar topics.

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.