Can't edit field in grid

User, date Message
Written by BubikolRamios
5 months ago
Category: General
273 posts since Thu, 14 Jan 10


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.
Written by BubikolRamios
5 months ago
273 posts since Thu, 14 Jan 10 		'That' column menas first column in resultset, that is, 'term' column.
Written by BubikolRamios
5 months ago
273 posts since Thu, 14 Jan 10 		+ The same message (on try edit) on all columns in result grid !
I think logical for all, except for first ...
Written by ansgar
5 months ago
3973 posts since Fri, 07 Apr 06 		This is a safety feature in HeidiSQL - it blocks editing if you have calculated fields in the result.
Written by BubikolRamios
5 months ago
273 posts since Thu, 14 Jan 10 		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.