View of multiple tables

Emerson A. Carneiro

Delphi Developer

Thu, 12 Oct 2000 03:00:00 GMT

View of multiple tables

Hi,

I'd like to know if there is a way to get a view of five table at same time.
I'm trying to use TQuery but without success. Is there anyone with any
suggestion ?

----------------------------------------------------------
Emerson Almeida Carneiro - Brazil
e.carne...@maile{*word*277}.com

Team

Delphi Developer

Thu, 12 Oct 2000 03:00:00 GMT

Re:View of multiple tables

If you want to see columns from each of the tables in a single record then a
query is the way to do it.

--
Bill

(TeamB cannot answer questions received via email.)
(To contact me for any other reason remove nospam from my address)

Emerson A. Carneir

Delphi Developer

Fri, 13 Oct 2000 03:00:00 GMT

Re:View of multiple tables

Thanks Bill

I've got the desired view. It was needed to return one empty query and
insert many records, but it doesn't stay in defined Order By. How can I
order these records after insert them ?

----------------------------------------------------------
Emerson Almeida Carneiro - Brazil
e.carne...@maile{*word*277}.com

Team

Delphi Developer

Fri, 13 Oct 2000 03:00:00 GMT

Re:View of multiple tables

You will need to re-run the query to reorder the records.

--
Bill

(TeamB cannot answer questions received via email.)
(To contact me for any other reason remove nospam from my address)

Other Threads

1. Multiple views to multiple tables (a lot of views to a lot of tables!)

2. View as view instead of view as table

3. Multiple views of the same tables?

4. TSQLQuery Multiple Params in Multiple Tables

5. One program...multiple forms...multiple tables...

6. Using Multiple Tables on multiple forms

7. Oracle 8 and SQL Explorer Table View Showing System Tables

8. Multiple views of the same DataModule

9. multiple 3D views

10. DataModules & Multiple row views