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]

Re: Other file name extensions for SQL files - how?

just... why?

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

Marc

[Scott Roberts]

Re: Other file name extensions for SQL files - how?


"Tom Dacon" <tdacon@communi ty.nospamwrote in message
news:erzZjylbIH A.4712@TK2MSFTN GP04.phx.gbl...

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]

Re: Other file name extensions for SQL files - how?

"Marc Gravell" <marc.gravell@g mail.comwrote in message
news:e$9QX0lbIH A.4208@TK2MSFTN GP04.phx.gbl...

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]

Re: Other file name extensions for SQL files - how?

Thank you, Scott - good tip.

Tom Dacon
Dacon Software Consulting

"Scott Roberts" <sroberts@no.sp am.here-webworks-software.comwro te in
message news:%23CL3WCnb IHA.5988@TK2MSF TNGP06.phx.gbl. ..

>
"Tom Dacon" <tdacon@communi ty.nospamwrote in message
news:erzZjylbIH A.4712@TK2MSFTN GP04.phx.gbl...

>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/t...7/Default.aspx