help I need to know whether this can be done

Jessica Fung

Delphi Developer

Thu, 10 Sep 1998 03:00:00 GMT

help I need to know whether this can be done

Hi,

I am in the midst of trying to do the following and would appreciate any
pointers and answers.

I am trying to design an order form that needs to pull information from
THREE or more different tables, can such a thing be done in Delphi, so
far from what I have read in the books it seems that Delphi allows you to
create links between two tables. Anymore than that, it says that it
can't open the Master Table....

Could somebody help me out please?

Thanks in advnace.
Jessica

2001 1002 Blade Runner rennuR edalB
B _______________________________ B
r Jessica Fung, r
a jkwf...@acs.ucalgary.ca a
z University of Calgary z
i Faculty of Management (MIS) i
L http://www.ucalgary.ca/~jkwfung L
M _______________________________ M
JoM Moj ST:TNG NGT:TS X-files TZ TZ
the traveller ! magine eht

Mark Vejvo

Delphi Developer

Sat, 12 Sep 1998 03:00:00 GMT

Re:help I need to know whether this can be done

Quote

Jessica Fung <jkwf...@acs.ucalgary.ca> wrote:
>Hi,
>I am in the midst of trying to do the following and would appreciate any
>pointers and answers.
>I am trying to design an order form that needs to pull information from
>THREE or more different tables, can such a thing be done in Delphi, so
>far from what I have read in the books it seems that Delphi allows you to
>create links between two tables. Anymore than that, it says that it
>can't open the Master Table....

You should be able to use an SQL statemaent using JOIN or UNION and
use as many databases and tables as you wish. Just declare each
database as a component of TTable of TQuery or whatever, and go wild.
(Read up on the SQL)

Temple Cav

Delphi Developer

Sun, 13 Sep 1998 03:00:00 GMT

Re:help I need to know whether this can be done

Quote

<jkwf...@acs.ucalgary.ca> wrote:

>Hi,

>I am in the midst of trying to do the following and would appreciate any
>pointers and answers.

>I am trying to design an order form that needs to pull information from
>THREE or more different tables, can such a thing be done in Delphi, so
>far from what I have read in the books it seems that Delphi allows you to
>create links between two tables. Anymore than that, it says that it
>can't open the Master Table....

>Could somebody help me out please?

Jessica, I currently have an app with databases structured as follows:

1-4 (Master to 4 child databases) all 4 child databases linked into master

I also tried, experimentally, to link 1-1-1. It seemed to work (No open
errors or exceptions), but I haven't used it with any real data.

In the case of the former, I haven't had any problems, other than
performance issues when child databases get around 10,000 records or so.

Anyway, hope that helps.

Temple

Arro

Delphi Developer

Sun, 13 Sep 1998 03:00:00 GMT

Re:help I need to know whether this can be done

In <4ja9eo$...@news.onramp.net> Temple Cave <c...@onramp.net> writes:

Quote

> <jkwf...@acs.ucalgary.ca> wrote:

>>Hi,

>>I am in the midst of trying to do the following and would appreciate
any
>>pointers and answers.

>>I am trying to design an order form that needs to pull information
from
>>THREE or more different tables, can such a thing be done in Delphi,
so
>>far from what I have read in the books it seems that Delphi allows
you to
>>create links between two tables. Anymore than that, it says that it
>>can't open the Master Table....

>>Could somebody help me out please?

>Jessica, I currently have an app with databases structured as follows:

>1-4 (Master to 4 child databases) all 4 child databases linked into
master

>I also tried, experimentally, to link 1-1-1. It seemed to work (No
open
>errors or exceptions), but I haven't used it with any real data.

>In the case of the former, I haven't had any problems, other than
>performance issues when child databases get around 10,000 records or
so.

>Anyway, hope that helps.

>Temple

There is absolutely no problem with a many-one one-many or 1-1-1-1
relationship anything your heart desires. Delphi is notoriously
excellent at that.

Ben
Arrow

Other Threads

1. Help with TThread: What am I doing wrong?

2. Help: How do you know when TQuery is done with it's fetch

3. How to know whether DB is being used ??

4. How to know whether printer is dot-matrix?

5. What am I doing wrong

6. What am I doing wrong?

7. What am I doing wrong...

8. What am I doing wrong?

9. TDBGrid onvalidate - what am i doing wrong

10. what am I doing wrong