C/S remote with EDB Manager

- table1 9339 rows
- table2 181 rows

create a view 'myview': "SELECT * FROM table1 INNER JOIN table2..."
- open the view (9339 rows browsing)
- goto database/SQL
- execute query: "SELECT * FROM myview"
- resultset contains 12 records

close all.

- execute query: "SELECT * FROM myview"
- resultset contains 9339 rows
- goto view and open
- 12 rows browsing

If I create a view from just one table without joins everythings fine.


ralf

Ralf,

<< create a view 'myview': "SELECT * FROM table1 INNER JOIN table2..."
- open the view (9339 rows browsing)
- goto database/SQL
- execute query: "SELECT * FROM myview"
- resultset contains 12 records

close all.

- execute query: "SELECT * FROM myview"
- resultset contains 9339 rows
- goto view and open
- 12 rows browsing

If I create a view from just one table without joins everythings fine. >>

Could you send me an example of what you're doing ?  I tried the following
here:

CREATE VIEW "TestView" AS
SELECT * FROM customer INNER JOIN orders ON
orders.custno=customer.custno
WHERE State='FL'

And it shows 21 rows no matter how I access it - SELECT, open, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com