Hi Buddy, The Statement is Fine there is a couple of things I do different. 1. I place the Linking statement at the front of the where ie.(C1.CourseID=G1.CourseID) 2. I use the @@Scope$Varname ie. @@User$gAssn >> I'm still in the Tango Editor and it is not even showing the database source. If you have Tango Server and Database on a server and are using the tango editor on a workstation you have to setup an ODBC definition on your workstation with the same name you are using on your server. Ben Johansen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walker, Buddy Sent: Monday, April 30, 2001 12:13 PM To: '[EMAIL PROTECTED]' Subject: RE: Tango Ben Here is the select statement, but I think I'm losing you. I'm still in the Tango Editor and it is not even showing the database source. *******Select statement************ SELECT CourseID,ASSN,CourseDesc,StartDate,EndDate,Grade FROM CourseDesc C1, GRADES G1 WHERE (G1.ASSN = '<@VAR gAssn>' AND G1.Grade IS NOT NULL) AND ((C1.CourseID=G1.CourseID)) ORDER BY 4 DESC **********End Select********* Buddy -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:56 PM To: [EMAIL PROTECTED] Subject: RE: Tango Hi Buddy, > 4. Select Tables .. (I select 2 tables only Grades, CourseDesc) So the select statement you typed into the Direct-DBMS correlates between Grades & CourseDesc? Can I See the Select Statement? Have you tried copying the select statement from the Direct-DBMS and running it at the R>Prompt >When I first try to use the ODBC Connection from within Tango it asks me >what tables to use, so I select the only two I want (Grades and CourseDesc). >Both tables are native to the Grades Database. the tables you select when you connect in the tango editor are for convience while working with tafs. There is no connection between these tables and the running connection setup in the Dirct-DBMS. each Direct-DBMS action is a self-contained process, the only interaction you have with the process is defining the Select Statement and working with the data that is returned with the <@ROWS> in the result. > Grades does use a SCONNECT to OSA and the SATTACH tables are StuData, >LeaveOFAbsence This actually might be the problem, what could be happening is this. 1. Tango Server processes the Direct-DBMS telling it to make a connection 2. The Connect through the main database is fine, but then oterro senses it need to open another connection to other database. 3. The new connection is then requiring user and password info, but since Tango opened the connection the request is showing up in Tango and then both Tango and R:Base are confused. Ben Johansen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walker, Buddy Sent: Monday, April 30, 2001 11:00 AM To: '[EMAIL PROTECTED]' Subject: RE: Tango Ben Steps I am using with tango are.. 1. Direct DBMS action 2. Select source (Grades ODBC) 3. Connect As... I just press OK 4. Select Tables .. (I select 2 tables only Grades, CourseDesc) 5. The next message I get is Oterro Connect (for another ODBC connection) and then I press cancel nothing happens. If I press OK, I will get the error message below. When I first try to use the ODBC Connection from within Tango it asks me what tables to use, so I select the only two I want (Grades and CourseDesc). Both tables are native to the Grades Database. Grades does use a SCONNECT to OSA and the SATTACH tables are StuData, LeaveOFAbsence Buddy -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 1:32 PM To: [EMAIL PROTECTED] Subject: RE: Tango Hi Buddy, So, your saying that the table in main database is the result of an sconnect to another database? if you do a list from R:Base does the table shows 'server' instead of row count? If the above questions are Yes, I am quite sure that since Tango is not in control of the odbc connection, that the ODBC request or data is getting lost. It is best to let tango control the odbc connections. you might try using a direct-dbms action to get the data. Ben Johansen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walker, Buddy Sent: Monday, April 30, 2001 8:37 AM To: [EMAIL PROTECTED] Subject: R:Tango I'm getting the following error when trying to set a data source with Tango editor. R:Tango 2000 Oterro 2000 Database RBW 6.5++ Windows 98 SE workstation OSA database --- names of students and other data. Grades database -- grades and schedules for students. I want the students to have access to their grades thru the web. The problem seems to occur because the Grades database has an odbc to OSA database. The reason I say the above is because it will ask me for the name and password for grades and then I click OK and then the ODBC connection comes up for the OSA database. Can someone else verify this. ********* Error Message*********** Date: Mon Apr 30 11:20:13 2001 Product: Tango Editor Version: 4.05.043 CD Key: my CD Key here Operating System: Windows 95, 4.10, 2222, A Unhandled exception: 0xc0000005 Address:0x1df0912 *************************************** Thanks Buddy
