Whole Tomato Software Forums
Whole Tomato Software Forums
Main Site | Profile | Register | Active Topics | Members | Search | FAQ
User name:
Password:
Save Password
Forgot your password?

 All Forums
 Visual Assist
 Technical Support
 Visual Assist cannot edit .sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hexlog
New Member

USA
2 Posts

Posted - Apr 09 2018 :  04:21:14 AM  Show Profile  Reply with Quote
---------------------------
Visual Assist
---------------------------
Visual Assist cannot edit dbo.mpm_deviceInfos.sql because the document was opened, likely by an external application, using a method that prevents full access by Visual Studio extensions. Close the document and open it from within Visual Studio.

MSSQL::\120.24.241.209\Iot.Mpm\sa\SqlTable\dbo.mpm_deviceInfos.sql
---------------------------
#30830;#23450;
---------------------------

feline
Whole Tomato Software

United Kingdom
17012 Posts

Posted - Apr 09 2018 :  08:43:09 AM  Show Profile  Reply with Quote
Unfortunately the message contains the key bit of information here, the IDE it's self is limiting editing of this file, and this isn't something that VA actually has any control over.

Based on the file path, is the SQL file being opened directly from a SQL database? Or is this from a network share? I have not seen this come up outside of Unreal Editor before.

zen is the art of being at one with the two'ness
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Apr 09 2018 :  11:21:44 AM  Show Profile  Reply with Quote
Sorry, looks like a false positive of an unrelated issue. We'll address it in the next release. case=115635
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - May 01 2018 :  4:47:44 PM  Show Profile  Reply with Quote
case=115635 is fixed in build 2270
Go to Top of Page

hexlog
New Member

USA
2 Posts

Posted - May 18 2018 :  11:55:07 PM  Show Profile  Reply with Quote
---------------------------
Visual Assist cannot edit dbo.scw_deviceCtrls.sql because the document was opened, likely by an external application, using a method that prevents full access by Visual Studio extensions.

ViewDataWindow_MSSQL__\_localdb__MSSQLLocalDB\Iot.Scw\sa\SqlTable\dbo.scw_deviceCtrls.sql

Do you want Visual Assist to reopen the file for you?
---------------------------
Yes(Y) No(N)
---------------------------

-------------------------------------

Can you disable this prompt?
Because he interfered with my normal work.

Step:
Open SQL Server Object Explorer-> View Data

Edited by - hexlog on May 19 2018 12:00:39 AM
Go to Top of Page

feline
Whole Tomato Software

United Kingdom
17012 Posts

Posted - May 19 2018 :  06:08:30 AM  Show Profile  Reply with Quote
Which version of the IDE and version of VA are you using?

If you say Yes, are you seeing the VA Navigation bar at the top of the editor window when you have a .SQL file open?

Using VS2017 and VA 2270 I am not seeing this message when opening a .SQL file from the Server Object Explorer window. But I am just double clicking on a SQL file in this view. Which types / items do I need to select in order to get "View Data" in the right click menu on an item in this view? I don't really know anything about SQL server, so I am working this out as I go along.

zen is the art of being at one with the two'ness
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - May 19 2018 :  07:03:16 AM  Show Profile  Reply with Quote
wow -- the bug that won't die... case=116561. Sorry, will address in next release.
Go to Top of Page

lex
Senior Member

36 Posts

Posted - May 26 2018 :  2:37:13 PM  Show Profile  Reply with Quote
I get this sometimes after a "Find in Files" search, when a new file is opened as a result of me pressing the shortcut to get to the next entry in the Find Results window. There are only cpp and h files that belongs to the solution in the search result. And it's a CMake solution if that makes any difference. I can't reproduce it on purpose, it just happens "randomly".

VA_X.dll file version 10.9.2270.0 built 2018.04.30
DevEnv.exe version 15.0.27130.2024 Community
msenv.dll version 15.0.27130.2024
Comctl32.dll version 6.10.16299.431
Windows 10 10.0 Build 16299.431

Edited by - lex on May 26 2018 2:40:06 PM
Go to Top of Page

feline
Whole Tomato Software

United Kingdom
17012 Posts

Posted - May 28 2018 :  08:56:47 AM  Show Profile  Reply with Quote
When this happens, if you look at VA's definition field, which is normally at the top of the editor window, on the right hand side, what is the full path for this file? I am wondering if there is anything "odd" about this path, perhaps mixed / and \ in the path?

zen is the art of being at one with the two'ness
Go to Top of Page

lex
Senior Member

36 Posts

Posted - May 30 2018 :  4:09:25 PM  Show Profile  Reply with Quote
quote:
Originally posted by feline

When this happens, if you look at VA's definition field, which is normally at the top of the editor window, on the right hand side, what is the full path for this file? I am wondering if there is anything "odd" about this path, perhaps mixed / and \ in the path?

It happened again now, and I think you're on to something.

The compiler output (in this case) points to a file that has both / and \ in its path. Every time I open it by double clicking in the output window I get that error from VA.

It's easily reproduced with a pragma message that prints an odd path of an existing file to the output window. Like this:
#pragma message("c:\\test/file.txt(1)")
Go to Top of Page

feline
Whole Tomato Software

United Kingdom
17012 Posts

Posted - Jun 01 2018 :  06:28:04 AM  Show Profile  Reply with Quote
This case appears genuine, due to the mixed slashes in the path. Is the problem the message, or the fact that VA is having to re-open the file to be fully active in the file?

The message explains the problem, and since we are working behind the scenes in the IDE, we don't have direct control over how the file is opened. The file has already been opened before we get involved here.

zen is the art of being at one with the two'ness
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jun 01 2018 :  1:17:32 PM  Show Profile  Reply with Quote
It appears that though the message text isn't completely correct, it is warranted. Some text input operations don't work if you do not allow VA to reload the file when the file has been opened with mixed path delimiters. We don't know what the problem with the VS document is, but some of our calls to VS text operations simply fail when the document is in that state. We found through trial and error that the operation failures occur when the document was opened with any unix-style path delimiters. The problem was originally reported for files opened in VS by the Unreal Editor. It never occurred to us that the problem could be repro'd through the output window.
Go to Top of Page

lex
Senior Member

36 Posts

Posted - Jun 01 2018 :  1:41:14 PM  Show Profile  Reply with Quote
quote:
Originally posted by feline

This case appears genuine, due to the mixed slashes in the path. Is the problem the message, or the fact that VA is having to re-open the file to be fully active in the file?

The message explains the problem, and since we are working behind the scenes in the IDE, we don't have direct control over how the file is opened. The file has already been opened before we get involved here.


Both. The message interrupts normal work flow. It's easy enough to press enter to let VA reopen the file, but then you lose focus on the error line because the caret is placed at the start of the file. If you don't let VA reopen the file then you can't edit the file normally. You can't type '.', auto complete suggestions doesn't work, indentation on enter doesn't work. It's just a mess.

I've found that compiler errors in headers that are included using a relative path with slashes instead of backslashes gives this "odd" path in the output.

Edited by - lex on Jun 01 2018 1:42:39 PM
Go to Top of Page

lex
Senior Member

36 Posts

Posted - Jun 01 2018 :  1:48:29 PM  Show Profile  Reply with Quote
quote:
Originally posted by sean

It appears that though the message text isn't completely correct, it is warranted. Some text input operations don't work if you do not allow VA to reload the file when the file has been opened with mixed path delimiters. We don't know what the problem with the VS document is, but some of our calls to VS text operations simply fail when the document is in that state. We found through trial and error that the operation failures occur when the document was opened with any unix-style path delimiters. The problem was originally reported for files opened in VS by the Unreal Editor. It never occurred to us that the problem could be repro'd through the output window.

Thank you for the info. It sounds like a VS bug then.
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jun 01 2018 :  1:48:50 PM  Show Profile  Reply with Quote
Thanks for the feedback. We should restore caret position after the reload. case=116840
Go to Top of Page

lex
Senior Member

36 Posts

Posted - Jun 01 2018 :  2:04:58 PM  Show Profile  Reply with Quote
Adding a "do not show this message again" option would be great too, if possible.
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jun 01 2018 :  2:20:55 PM  Show Profile  Reply with Quote
You can disable the prompt entirely via the registry -- but no reload occurs.

Exit all instances of VS, open regedit, goto HKEY_CURRENT_USER\Software\Whole Tomato\Visual Assist X\VANet15 and change WarnOnLoadOfPathWithReversedSlashes from 01 to 00.

We'll update it to support reload without prompt also. case=116843
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jul 13 2018 :  2:45:17 PM  Show Profile  Reply with Quote
case=116843, case=116561 and case=116840 are addressed in build 2283.

Registry value WarnOnLoadOfPathWithReversedSlashes is now a DWORD. A value of 2 will silently reload files that contain any forward slash. Caret position is restored after reload.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
© 2019 Whole Tomato Software, LLC Go To Top Of Page
Snitz Forums 2000