Hi.
Using Visual Studio 2002 and ODBC DataReader, I cannot work out how
to get SQL queries to work where there are hypens in the field name.
eg.
No problem.
"SELECT PUB.debtor.Name FROM PUB.debtor"
Won't work.
"SELECT PUB.debtor.deb-accn FROM PUB.debtor"
It's something to do with that hypen. I've tried everything I can
think of - but I'm at a loss as to how to solve this.
Ideas will be helpful.
Thanks.
Using Visual Studio 2002 and ODBC DataReader, I cannot work out how
to get SQL queries to work where there are hypens in the field name.
eg.
No problem.
"SELECT PUB.debtor.Name FROM PUB.debtor"
Won't work.
"SELECT PUB.debtor.deb-accn FROM PUB.debtor"
It's something to do with that hypen. I've tried everything I can
think of - but I'm at a loss as to how to solve this.
Ideas will be helpful.
Thanks.