New topic: Need help with spaces in Column Names
<http://forums.realsoftware.com/viewtopic.php?t=47234> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message tseyfarth Post subject: Need help with spaces in Column NamesPosted: Sat Mar 09, 2013 2:55 pm Joined: Sat Dec 04, 2010 9:14 pm Posts: 830 Hello all, I have a legacy Pervasive Database that I am trying to work with using ODBC. I can connect and attempt to get data, but an error is returned on each column that has a space in the name. How do I get around this? Error: [Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface]Syntax Error: SELECT RemoteAddress,Slot,<< ??? >>[Module Device Number],BldgNo,[Door No],Lock_State, Door_State,[Date In],[Time In],[Date Out],[Time Out],[Event Description],[Event Status],GateCode,[Tenant FName],[Tenant L Column: "Module Device Number" I removed this Column from the list, and then the complaint moves to the next Column Name with a space in it, "Door No". Any ideas would be really appreciated! Thank you, Tim Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
