Report based on a View, rather than a Table

rbuser

Hi,

I have built a report based on a view. When I try to execute that, I receive
an error message like this:

TdaMetaCache.GetFields: unable to find table VIW36PRO in cache.

How can I do to fix it?

Just to face the situation, I have a master table if 12 lookup tables. To
avoid 13 queries, I built a view to join all tables, just to keep it simple
to use.

Thanks a lot.

Giovani Marinho
Brazilian Delphi Developer.

nardmoseley

The RB Dade plug-ins do not currently support table views. However, after
posting the above message you sent the following suggestion to
suppot@digital-metaphors.com for a proposed solution.

Thanks! We'll look at adding this code to the next release....


{---------------------------------------------------------------------------
---}
{ TdaIBXSession.GetTableNames }

procedure TdaIBXSession.GetTableNames(const
aDatabaseName: String; aList: TStrings);
var
lDatabase: TIBDatabase;
lTable: TIBTable;

begin
{get the database}
lDatabase := daGetIBXDatabaseForName(aDatabaseName);

lTable := TIBTable.Create(nil);
lTable.Database := lDatabase;

{this is a new line, not Digital Metaphors default,
to allow You to make a report based on a View too,
rather than just using Tables}
lTable.TableTypes := [ttView];
.......



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com