CodeBase SQL joins

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Mike_Brumley_(Guest)
Posts: 12
Joined: Tue Oct 10, 2017 12:44 pm

CodeBase SQL joins

Post by Mike_Brumley_(Guest) » Tue Mar 15, 2005 10:54 am

This is still not working right. In RSWSQL.INI, I have a section with:____JoinAcrossDir = 1__DataSourceDBTerm = DIRECTORY____I can now use the Related Table, Directory button to select a different directory. When I click on OK in Browse for Folder, I no longer get an error. I also don^t get anything new - no matter what the new path is, I still see a file list from the original path. The Directory label does show the new path, it^s just not showing any files from there.____I noticed that if I select a table from this list to try the Join, I get an "Unable to locate table" error. Just for fun, I made a test dir and copied a table from the Master Table path to it, then selected that dir and joined to that table - that did not cause an error. So, it looks like RR 90% knows where it^s supposed to be, it^s just the table list that doesn^t.____The only other setting I could see that might affect this was DataSourceUsesDirPrefix, no change though. What else could I be missing here?____Thanks,__Mike Brumley__

Post Reply