v10 SQL table locations

[Mike_Brumley_(Guest)]

That may look like an oxymoron, but when you^re using the SQL version against the CodeBase ODBC/SQL driver, you actually can have tables in places other that the path specified in the DSN, since each table is ultimately still a physical dbf. It looks like you weren^t expecting anyone to do this, since there doesn^t seem to be a way to specify a table location when creating joins. All you get is a list of "tables" - the dbf^s in the DSN source path. However, when using the xBase-SQL conversion wizard, you can edit the table name, and it will accept a full path, which is also displayed if you edit the join in the Report Designer. (I^m not sure if the Wizard is supposed to be used that way though, since no report I^ve tried that on will actually work once it^s converted.) The DDE also seems to have no way to add tables or edit their location. So, a couple questions:____ 1) Is there some way to do this in v10 that just I haven^t found?____ 2) The May 2005 enhancement "Redesigned Table Selection dialog" looks like you^re doing a lot of work on table selection - any chance that will include specifying paths?__

[Mike_Brumley_(Guest)]

Well, I thought I had figured this out on my own, but now it seems I have some different questions instead. I created separate DSN entries for the CodeBase ODBC driver for each dbf directory, and then added each DSN as a data source connection. At this point, things get a little weird. According to the R&R help file, the Related Tables dialog is supposed to have options for "Look In", "File Name", and "Files of Type". (That whole section reads as though it^s really meant for the xBase version - only the xBase version Related Tables dialog is completely different.)____The Related Tables dialog I actually see is different, and a bit messed up. I have a listbox filled with tables from the first data source I added. Below that are three buttons - OK, Cancel, and Help. Help is misaligned, about 20% lower than the first two. Below the OK button it looks like something might be there, but is clipped by the bottom of the dialog.____Am I supposed to be seeing *something* that would let me switch data connections? Is my install somehow messed up? I have 10.1.003 - the file dates match those online, though I see some dll^s which are supposed to be 3/22 are 3/24.____Thanks,__Mike Brumley__

[kfleming]

You need to edit the file RSWSQL.INI and find the section that is being used for your data source. You may need to create this section since it likely does not exist.____If the section has the setting:__JoinAcrossDir=1____then the table selection dialog will include DataSource and Directory buttons.____Kathleen__R&R Support

[Mike_Brumley_(Guest)]

Well, I have the buttons showing up now. But when I try to create a join on a table in another directory, when I click Ok on the Browse for Folder dialog, I get an R&R SQL error:____DB Access: RR SET JOIN: [CodeBase][CodeBase Engine ODBC Driver] Syntax error in connection string.____Seems odd, since at this point I^ve selected a path, but not a table, so I^m not sure what it would be trying to join. ____So far the only change I^ve made to RSWSQL.INI is to add an [xBase (*.dbf)] section with a JoinAcrossDir = 1 setting. Are there other settings I need?____Also, although I have several Data Sources defined, the only one I ever see when creating a join is the one selected when the report was first created - should I be seeing the others also?____Thanks,__Mike Brumley__

[Mike_Brumley_(Guest)]

Somehow that section name got lost, something about square brackets? Anyway, it^s:____xBase (*.dbf)