Not showing the complete SQL code of the view

Hello,

when I open a view with Heidi (version 9.3.0.4989) some views are not displayed completly. There are missing big parts from the statement.

When I go to the Data tab the data is displayed correctly and I also can execute a SELECT * on the view and get back data without any errors.

The problem is I can't work on those views now...

I attached an image of the problem. I just stops after the STU but there should be more...

I'm using a Windows 8.1 PC.

What can I do?

Thanks for your help...

Check if you have commented code in your view (vith some other editor). Sometimes that messes things.

If not something else wrong.

Check if you have commented code in your view (vith some other editor). Sometimes that messes things.

If not something else wrong.

Sadly that's not the case...

Any other ideas?

Apart from something wrong in hedi, check also HEX, or copy/pate into win Edit pad & resave. That should hopefuly remove all strange not visible characters.

Apart from something wrong in hedi, check also HEX, or copy/pate into win Edit pad & resave. That should hopefuly remove all strange not visible characters.

What do you mean with "check also HEX"?

I copy pasted the code from the server into Heidi and saved the view. After restarting Heidi the problem apears again...

copy pasted the code from the server

You could copyed some non visible characters thet heidi will not digest well.

Hexadecimal view of text, there might be some strange characters after your "STU", or realy anywhere else in text.
That might be a problem.

As said, copy 'from server' <-- have no idea what is that, into edit pad,save and then copy from edit pad to heidi. If there is HEX problem, that mostly solves it.