Can't edit field in grid

BubikolRamios posted 5 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]
[Main Instruction]
Grid editing error
Column #1 has an undefined origin: locate(' ',term)

Does not look logical.
BubikolRamios posted 5 years ago
'That' column menas first column in resultset, that is, 'term' column.
BubikolRamios posted 5 years ago
+ The same message (on try edit) on all columns in result grid !
I think logical for all, except for first ...
ansgar posted 5 years ago
This is a safety feature in HeidiSQL - it blocks editing if you have calculated fields in the result.
BubikolRamios posted 5 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.

Please login to leave a reply, or register at first.