I'm using InfoMaker 5.0.03 to run reports from an Oracle 7.3
database. The problem is, the DB provider has just changed the table
setups, moving some values I used in reports into other tables, and
renaming some entirely. My question is: is there any way to change the
table name used by a 'Quick Select' Report in InfoMaker 5? If not, I
have to rebuild about 10 reports by next week. Any ideas? By the way,
if this is a stupid question, I apologize in advance, but this is only a
part-time (student) job, and I don't have a lot of time to do all of the
Thanks in advance,
Mark A. Rakes
Date: Thu, 22 Jan 1998 15:38:52 -0800
From: Mark Rakes <firstname.lastname@example.org>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
Subject: the tables have turned!!!
Content-Type: text/plain; charset=us-ascii
Xref: forums-1-dub sybase.public.infomaker.general:7311
Article PK: 244367
From: "Terry Dykstra [TeamPS]" <email@example.com>
Subject: Re: the tables have turned!!!
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 23 Jan 1998 13:36:20 -0500
Xref: forums-1-dub sybase.public.infomaker.general:7310
Article PK: 244365
It is definitely not a stupid question. Go into the report, and then into
the SQL painter by clicking on the SQL Data button. You will see the list
of tables used in the query. From here you can click on the tables button
and select the renamed tables. Select the desired columns, create new
joins and then remove the undesired table(s) by rightclicking on the
table's grey bar and selecting close. If the column names in the old and
new tables are the same, your report should run unchanged.
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.