Hi

i have a DB with EDB 2

500 tables, 5 View

i should to work my clients with Report Builder End User editor

for access to ( ONLY ) View table.

but.. i cant' access to this ( all ) view.

in RB Editor i can see all my 500 TABLE, But Zero VIEW.


How i can access to VIEW ?
How i can block to access at the TABLES ?


Berst Regards

Mauro,

<< for access to ( ONLY ) View table.

but.. i cant' access to this ( all ) view.

in RB Editor i can see all my 500 TABLE, But Zero VIEW.

How i can access to VIEW ?
How i can block to access at the TABLES ? >>

You'll probably need to take this up with Digital Metaphors, but most likely
the issue is that they're not querying the database catalog for views, only
tables, for the selection of the tables in the end-user query editor.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mauro,

you will have to alter the dade component of ReportBuilder (rbEDB...) .

In "daElevateDB.pas" look at the function "GetTableNames".  Currently it uses
TEDBSession.GetTableNames. I think if you just replace that with a query to the catalog
("select name from information.views") it should work the way you want.

Heiko

Heiko,

<< In "daElevateDB.pas" look at the function "GetTableNames".  Currently it
uses TEDBSession.GetTableNames. I think if you just replace that with a
query to the catalog ("select name from information.views") it should work
the way you want. >>

Actually GetTableNames returns both tables and views.  That's how a
TEDBTable component can use a view like a normal table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

>>Actually GetTableNames returns both tables and views.

Wasn't aware of that, since I never used views. Tried it now, and yes, I can access both
tables and views from inside ReportBuilder.

Heiko

>>>Actually GetTableNames returns both tables and views.
>
> Wasn't aware of that, since I never used views. Tried it now, and yes, I
> can access both
> tables and views from inside ReportBuilder.

Have you used a DATADICTIONARY Turn on ?

Designer.DataSettings.UseDataDictionary  , value ?

Mauro,

No, I don't use the DataDictionary.

Heiko

> No, I don't use the DataDictionary.

if you active D.D.  the function getnames...... is not more called.




how i can add the VIEW in the DataDictionary ?

Mauro

I try it tomorrow. Can you post the "CREATE TABLE" SQL for the DataDictionary tables ?

Heiko

Mauro,

tried it, and sorry, I couldn't even open the Datadictionary Builder.

In Datadictionary.BuilderSettings.SessionType there is no EDBSession, only BDE/ADO/IBX, so
I can't connect it to my database, despite of working dade components.

Heiko