Page 1 of 1
Joins
Posted: Tue Jul 06, 2004 8:27 pm
by Stephen_Menere_(Guest)
I^m using R&R ver 10 and Pervasive ODBC on a Btrieve table and when I try to do a join, I get the ^Related Table^ screen but it doesn^t show the ^Data Source^ button.__
=> RE: Joins
Posted: Thu Jul 08, 2004 3:33 pm
by kfleming
You will only see a Datasource button if the file RSWSQL.INI contains an entry stating:__JoinAcrossDir=1__in the appropriate section of the the file that points to the database platform you are using.____Kathleen__R&R Support
==> RE: Joins
Posted: Thu Jul 08, 2004 7:33 pm
by Stephen_Menere_(Guest)
This was already set up but I noticed that it had spaces before and after the ^=^ sign. Removing the spaces fixed the problem on an NT PC but doesn^t correct the problem on a Windows2000 PC. Any other ideas?
===> RE: Joins
Posted: Mon Jul 12, 2004 9:52 pm
by Stephen_Menere_(Guest)
In the "Readme.rtf" Release Notes for September 09 2003 Update Version 10.1.003, I found a passage under the sub heading "SQL Server7/2000" which stated "1. Auto SQL reports are limited to selecting tables from the current login database.__2. If you need to join tables across databases, you can create a User SQL report or can within you database build a View table that references tables from a different database."____Would this be the cause for the issues I have with the joins??__
====> RE: Joins
Posted: Mon Jul 12, 2004 10:34 pm
by kfleming
Not really the same issue.__Are you using the same ODBC driver on both machines?____Kathleen__R&R Support
=====> RE: Joins
Posted: Tue Jul 13, 2004 7:25 pm
by Stephen_Menere_(Guest)
Both are Pervasive ODBC^s