View Editor

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago in General Permalink

Hi, i have to edit a mssql view, but i can't see everything of the code in the editor. It breaks after (round about) 3000 characters. Is there a possibility to increase the number of characters? I really need this to edit the view because of an error in it.

Best regards Robert

ansgar's profile image ansgar posted 7 years ago Permalink

The current HeidiSQL version uses an approach described in this thread to overcome the 4000 character limit for views. Please watch out for that EXEC sp_helptext 'dbo.nameofview' on your side, and what it returns.

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

This fits the problem, but isn't it possible to edit anything of a view directly in the editor?

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

And thank you for your fast answer.

ansgar's profile image ansgar posted 7 years ago Permalink

The view editor should already fire that EXEC sp_helptext... query itself, and if the query returns the full body, the view editor should also display the view editor. If not, that's probably a new bug in Heidi.

Are you on the latest build with Heidi?

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

Oh yes. Now there is also the hole view visible in the view editor. Thank you!

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

Oh yes. Now there is also the hole view visible in the view editor. Thank you!

EDIT: No i'm sorry, but i was wrong! There is also not the hole view visible in the editor. I only get a result table with the hole view, but there i can't edit anything, so it is not very useful. I work with version 9.3.0.4984. Is there any possibility to edit the hole view?

ansgar's profile image ansgar posted 7 years ago Permalink

Please update to the latest build to see if that was fixed.

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

Well i use the portable version of heidi. Could it be that this is the mistake?

ansgar's profile image ansgar posted 7 years ago Permalink

What's the problem with updating to the latest build?

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

I cannot find a newer version of heidi sql portable?

[expired user #10127]'s profile image [expired user #10127] posted 7 years ago Permalink

Well now i have change the view with a Query.

ansgar's profile image ansgar posted 7 years ago Permalink

You can update the portable version via Help > Check for updates.

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