Using ODBC to query data directly from OG files, has anyone found a way to get around the problem of Field names with spaces? I have tried every practical convention I can think of: put field names in square brackets "[", put field names in double quotes, use %20 for the space, etc. nothing seems to work, so SELECT statements fail unless I do a select *. The problem seems to originate in the Filemaker driver that parses the select statement?
Thanks for the input anyway. From what I have been able to determine by reading the tech-know on FM ODBC driver, spaces in field names are not supported. The support spaces in file names (use %20), but no mention of spaces in field names. Seems rather odd that Filemaker would write a driver that doesn't support spaces in field names even though their software allows spaces in field names. How lame is that.
Seems rather odd that Filemaker would write a driver that doesn't support spaces in field names even though their software allows spaces in field names. How lame is that.