#1438 SynMemo restricts editable lines to a length of 1024 chars

[Anonymous]

Originally created by: geets.st...@gmail.com

What exact steps will reproduce the problem?
1.select a view
2.ALT ENTER to edit or select right mouse click

What was the expected output? Normal edit of query
What happened instead?When editing the query I can't insert characters.
removing is ok.

Suggested fix (optional)?

Version used?
HeidiSQL revision: Version 4.0 Rev 2642 compiled 2009-09-17 09:52:16
MySQL Server version:5.1.37
Operating system: Windows XP

[Anonymous]

Originally posted by: a...@anse.de

Duplicate to issue 723

Mergedinto: 723
Status: Duplicate

[Anonymous]

Originally posted by: a...@anse.de

Sorry, I misread your description - thought you mean query results.

Labels: Severity-Broken
Mergedinto: -723
Status: Accepted

[Anonymous]

Originally posted by: a...@anse.de

Cannot reproduce that. I can edit all views here. Could you please update to the
latest build (About > check for updates) and report back if the problem persists?

Status: NeedInfo

[Anonymous]

Originally posted by: geets.st...@gmail.com

Same result with the latest build. I had to downgrade, because the cancel buttom
when executing a query is not appearing anymore

Correction : Operating system is Windows server 2003.

I have a few tests in mind. I come back to you

[Anonymous]

Originally posted by: geets.st...@gmail.com

I was thinking it was related on the remote desktop connection I used towards the
Windows server 2003 with the HeidiSQL client installed locally. But it was not.  I
installed the client on a windows XP machine, connected succesfull to the MySQL DB
on the win server 2003 machine.
I opened the view window in edit mode.  I still can remove characters, but inserts
are not working. Weird

[Anonymous]

Originally posted by: a...@anse.de

Yes, weird indeed. If you look at the sources in trunk/sources/view.pas you won't
find any line which says
  SynMemoSelect.Enabled := False
or
  SynMemoSelect.ReadOnly := True
or something similar.

Ideas:
- Is it *one specific* view we are talking about or is it the same with *all* views?
- Could you, for debugging purposes, paste the SELECT body from one of those non
working views?

Status: Accepted

[Anonymous]

Originally posted by: geets.st...@gmail.com

I found something ! It seems to be a text buffer issue;

The view is quite long, mostly a need to addapt the query at the end.(a date
setting).
If I perform an edit at the beginning of the query, editing works fine. It seems
that I can't edit after the 1023's character (close to 1024 isn't it ?)

try this one :

select `mameva`.`events_mm`.`events_id` AS
`events_id`,`mameva`.`events_mm`.`drop_id` AS
`drop_id`,`mameva`.`events_mm`.`import_name` AS
`import_name`,`mameva`.`events_mm`.`file_name` AS
`file_name`,`mameva`.`events_mm`.`event_id` AS
`event_id`,`mameva`.`events_mm`.`start_time` AS
`start_time`,`mameva`.`events_mm`.`end_time` AS
`end_time`,`mameva`.`description_mm`.`title` AS
`title`,`mameva`.`description_mm`.`subtitle` AS
`subtitle`,`mameva`.`description_mm`.`short_description` AS
`short_description`,`mameva`.`description_mm`.`short_synopsis` AS
`short_synopsis`,`mameva`.`description_mm`.`long_synopsis` AS
`long_synopsis`,`mameva`.`description_mm`.`series_id` AS
`series_id`,`mameva`.`description_mm`.`series_name` AS
`series_name`,`mameva`.`events_mm`.`rating` AS `parental` from (`mameva`.`events_mm`
join `mameva`.`description_mm`) where ((`mameva`.`events_mm`.`events_id` =
`mameva`.`description_mm`.`events_id`) and
(`mameva`.`description_mm`.`language_code` = 'nld') and
`mameva`.`events_mm`.`drop_id` in (select `p1`.`drop_id` AS `drop_id` from
`mameva`.`uploads` `p1` where ((`p1`.`type` = 'Live') and (`p1`.`date` > '2009-11-04
00:00:00'))))

[Anonymous]

Originally posted by: a...@anse.de

Confirmed! Looks like a bug in SynEdit. And it's also in the normal query editor.

Summary: SynMemo restricts editable lines to a length of 1024 chars

[Anonymous]

Originally posted by: a...@anse.de

Fixed it! SynEdit has a MaxScrollWidth property which was set to 1024 and restricted
editable lines to have a maximum of 1024 chars. Just decreased this value by factor
10 (10240) to come around that. Strange property, can't imagine for what this is useful.

Fixed in [r2723].

Status: Fixed

[Anonymous]

Originally posted by: a...@anse.de

This issue was closed by revision [r2927].

Mergedinto: -