Printable View
I am using the control that has a tool tip "Data"
I am trying to get information from a table.
the table name is "Job List" this name has a space in it.there are fields that have spaces in there names as well.
It is giving me problems. is the space causeing problems? how do I get around this. I can NOT change the database table name or field names.
thank you for your time and have a good day
------------------
I am so skeptacle, I can hardly believe it!
No doubt Space is causing problems.
I think of only one thing without changing the database.Using Square brackets[ ]
Use the table names in Square brackets
eg:
Select * from [job List]
You should do the same with the field names too. It cannot recognize whether it is a keyword or tablename or variable name.
If it doesn't work, then there is no possible way except to change the database.
Good luck,
krishna
you da man!!!! :D :D :D :D :D :D :D:
------------------
I am so skeptacle, I can hardly believe it!