This field currently cannot be modified

Hi,

when I execute a simple select query on some tables, I can't modify columns values.

For example :

select col_libelle, col_code from COL_Colors;

When I try to edit value, I receive an error 

This field currently cannot be modified

I can execute an update query, so this isn't a privilege problem.

Is there an explanation ?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi,

    SQLPro only allows updating fields if it is able to detect the table name and primary keys for the table (your table MUST contain a primary key for SQLPro to be able to perform an update). If SQLPro is detecting the primary properly the column should turn blue.

    Like
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 188Views
  • 2 Following