I wrote a SQL statement in the data tab. I wrote a bunch of alaises as example ' word-type ' but when I hit the layout tab it converts the "-" to "_". So now my field name is ' word_type '. Is there any way to prevent this?
CardGunner
![]() |
0 |
![]() |
Don' use a hypen ( - ). It isn't a valid character for column names.
See http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1188931,00.html
Here's an excerpt about column names:
![]() |
0 |
![]() |
Easier said then done. I have to export to a client an xml file. He is expecting the column names to have the hyphen (-).
CardGunner
![]() |
0 |
![]() |
I called the client and he will edit it in his side. So it's no longer an issue but i'm curoius on the solution if he couldn't or wouldn't edit my download to him.
CardGunner
![]() |
0 |
![]() |