Other file name extensions for SQL files - how?

[Tom Dacon]

Google groups didn't offer any help on this, and I tried this in the
vsnet.ide newsgroup but didn't get a response. I'm trying it here in hopes
that someone might have a clue:

The company I work for uses a couple of non-standard file name extensions
for files containing SQL: .vw for views, .prc for stored procedures. The VS
IDE doesn't recognize these as SQL files, so it doesn't do syntax coloring
like it does for files with the extension .sql.

In the Options dialog under Text Editors/File Extension, if you try to add
these extensions the dropdown list of editors doesn't contain the SQL
editor. How can I link those extensions to the SQL editor? Any suggestions?

Thanks,
Tom Dacon
Dacon Software Consulting

 

[Marc Gravell]

just... why?

If you want that, why not try calling them foo.vw.sql, bar.prc.sql?

Marc

 

[Scott Roberts]

Google groups didn't offer any help on this, and I tried this in the
vsnet.ide newsgroup but didn't get a response. I'm trying it here in hopes
that someone might have a clue:

The company I work for uses a couple of non-standard file name extensions
for files containing SQL: .vw for views, .prc for stored procedures. The
VS IDE doesn't recognize these as SQL files, so it doesn't do syntax
coloring like it does for files with the extension .sql.

In the Options dialog under Text Editors/File Extension, if you try to add
these extensions the dropdown list of editors doesn't contain the SQL
editor. How can I link those extensions to the SQL editor? Any
suggestions?

Thanks,
Tom Dacon
Dacon Software Consulting

http://www.engagesoftware.com/Blog/tabid/297/EntryID/117/Default.aspx

 

[Tom Dacon]

just... why?

If you want that, why not try calling them foo.vw.sql, bar.prc.sql?

Marc

I don't want that - it's the company's naming convention, and the files are
in source control under names like that. I can't do anything about it, but
I'd like to be able to edit them more easily, and getting the IDE to
recognize them as SQL files would do that for me.

Tom

 

[Tom Dacon]

Thank you, Scott - good tip.

Tom Dacon
Dacon Software Consulting