Can't edit field in grid

632 posts

BubikolRamios posted 11 years ago in General

select term,locate(' ',term) ,locate(' ',term,locate(' ',term)+1), 
LEFT(term,locate(' ',term,locate(' ',term)+1)),
RIGHT(term,length(term)- locate(' ',term,locate(' ',term)+1))
from table
where term regexp('[0-9]')

This is select from one table, and 'term' is a column.
When I try to edit that column in grid -->

[Window Title]
Error
[Main Instruction]
Grid editing error
[Content]
Column #1 has an undefined origin: locate(' ',term)
[OK]

Does not look logical.

632 posts

BubikolRamios posted 11 years ago

'That' column menas first column in resultset, that is, 'term' column.

632 posts

BubikolRamios posted 11 years ago

+ The same message (on try edit) on all columns in result grid !
I think logical for all, except for first ...

10152 posts

ansgar posted 11 years ago

This is a safety feature in HeidiSQL - it blocks editing if you have calculated fields in the result.

632 posts

BubikolRamios posted 11 years ago

How would that represent safety risk ?
I think block of editing calculated fields would be sufficient, as there is no reason to edit them anyway.