Whole Tomato Software Forums
Whole Tomato Software Forums
Main Site | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Visual Assist
 Technical Support
 Database Project Files (.sql) not shown in OFiS

You must be registered to post a reply.
Click here to register.

Screensize:
UserName:
Password:
Format: BoldItalicizeUnderlineStrikethrough Align leftCenterAlign right Insert horizontal ruleUpload and insert imageInsert hyperlinkInsert email addressInsert codeInsert quoted textInsert listInsert Emoji
   
Message:

Forum code is on.
Html is off.

 
Check to subscribe to this topic.
   

T O P I C    R E V I E W
kperkins Posted - Jan 14 2008 : 10:38:00 PM
I installed the 1624 build of the Visual Assist X Trial today, and when opening a solution containing 3 C# Library projects, 1 asp.net website project, and 1 Database project, none of the .sql files are shown in the Visual Assist OFiS dialog unless they are currently open in the editor.

Any ideas? This is a deal breaker as I have hundreds of SQL files that I need access to.
6   L A T E S T    R E P L I E S    (Newest First)
feline Posted - Dec 29 2009 : 5:14:24 PM
You might find these FAQ's on dealing with other file extensions useful:

http://docs.wholetomato.com?W328

http://docs.wholetomato.com?W353
steel_3d Posted - Dec 22 2009 : 2:58:53 PM
I am blind. In the Open File in Solution dialog there's a checkbox for "Show only files in the current solution". Once I uncheck this I can find my shader files no problem.
steel_3d Posted - Dec 22 2009 : 2:52:53 PM
I have a very similar problem. I used to be able to open .fx (shader) files that were currently open in the solution in VS2005, but I can't get it to work in VS2008 no matter what I do. I've tried editing every registry key I could find. My issue is slightly different than the OP's because I COULD actually open my shader files in 2005. He was probably missing some of the registry keys I had. So what changed between 2005 and 2008, and can you guys make the OFiS work like it did in 2005?

I do have syntax highlighting and variable name suggestions and all the other good stuff working though. As an aside, for anyone who's interested, this is how I got the shader files recognized as source files by VA under VS2008:

1. In Visual Studio Tools/Options/Text Editor/File Extensions select Visual C++ as the editor and add cgfx and inc as extensions.
2. Close Visual Studio.
3. Create a text file called usertype.dat in C:\\Program Files (x86)\\Microsoft Visual Studio 9.0\\Common7\\IDE with the shader language keywords in it. Here's a post that shows how to get a good usertype.dat: http://www.gamedev.net/community/forums/topic.asp?topic_id=440816&whichpage=1#2924456
4. Add the extensions ".cgfx;.inc;" to the registry entry HKEY_CURRENT_USER\\Software\\Whole Tomato\\Visual Assist X\\VANet9\\ExtSource
5. Restart Visual Studio.
feline Posted - Dec 02 2009 : 09:14:30 AM
Unfortunately not much progress so far. We have had a look at this, but in VS2005 at least the IDE makes it hard work to find the .sql files. We are still considering this, since VS2008 might offer a way forward.
Nobodo Posted - Dec 01 2009 : 1:59:52 PM
Is there any progress on this?
I often work on projects that have database projects, and the *.sql files are part of the solution just the same as all the .cs and .aspx files. It would seem the OFiS should be able to find the files since they are part of the solution; instead I end up using VA to find C# files and something else to locate stored procedures, triggers, etc.

Thanks,
Mark.
feline Posted - Jan 15 2008 : 09:04:32 AM
An interesting idea. I have put in a feature request to add SQL files to the Open Files dialog:

case=11425

© 2023 Whole Tomato Software, LLC Go To Top Of Page
Snitz Forums 2000