Posted by J.O. Aho on 01/09/06 18:58

jj wrote:
> Thanks for the reply.
>
> My problem isnt that there are duplicates. My table is as simple as it
> possibly gets:
>
>
> table name : UPS
>
> --------------
> discount(PK)
> --------------
> 0.33
> --------------
>
> It only has one value in the entire table.
>
> Now if I try to alter the 0.33 to any value it just reverts back to the
> 0.33. No error is given at all either.

Okey, what SQL server do you use (name and version)?
What about does the user you logged into the SQL server has the right to
modify it? There is the GRANT that will be needed to be issued by the SQL
admin user to allow other users to get the priviliges to do different things
with databases and tables.

You can try the ALTER to modify the table so that the column no longer will be
the primary key.


For Mysql:
http://dev.mysql.com/doc/refman/5.0/en/grant.html
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


//Aho

• Next in forum: Re: Cant alter data in primary key fields
• Prev in forum: Re: Cant alter data in primary key fields
• Thread view: Re: Cant alter data in primary key fields

[Reply to this message]