Select statement problem 1

[ziggs]

Here's what won't work:

SQL = "Select * from TBL-CASES"
set rs = my_conn.Execute(SQL)

However if I change the name in the database from TBL-CASES to CASES, it will work. Thus, I'm thinking it doesn't like the hyphen.

I can't really change the Database design. So, how can I include the hyphen in Select statement?

 

[FengShui1998]

ziggs,

You got that right! Use

SQL = "Select * from [TBL-CASES]"
set rs = my_conn.Execute(SQL)




fengshui1998

 

[ziggs]

Hmmm, it didn't work. I must be missing something. Again, if I changed the database table to CASES instead of TBL-CASES, it seemed to work for some unknown reason. I was taking a guess that I needed to insert different characters in the SQL langauge to replace the hyphen.

 

[JohnYingling]

Is that a HYPHEN i.e. a minus sign? TBL-CASES. I'm know little of SQL but I think a hyphen is not good...but I could be wrong.

http://www.VBCompare.com

http://www.VBSortGen.com

 

[ziggs]

yes, it's a hyphen, aka/ minus sign. That might be my problem and since it's not my database to change, I can't do a thing until I solve this problem. Thanks

 

[FengShui1998]

ziggs,

I have an SQL database that has tables with hyphens and this works fine.

strSQL = "SELECT * FROM [" & tbl & "]"

Maybe Access does not like columns with hyphens but SQL does?

fengshui1998

 

[vasah20]

if you have access to the database, try making a query using the query designer. see what format the - gets put in... it's possible that [table-name] won't work, but table\-name might...

 

[jitter]

Strange....I tried your code and connected to both Access97 and SQL Server 7 just fine. I had to surround the TBL-CASES with [] just as FengShui1998 stated but after that everything worked. I don't know what could be causing your code to not work properly.

 

[jitter]

I don't know if it makes a difference but what is your connection string ziggs?