When querying directory access proxy tables, you must be consistent in your use of path name delimiters. It is best to use your platform's native delimiter: on Windows use \ and on Unix use /. Although the server also recognizes / as a delimiter on Windows, remote data access always returns file names using a consistent delimiter; therefore a query with inconsistent delimiters does not return any rows.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|