Re: Building master detail relationship
From: Barak zabari (lotemlotad_at_yahoo.com)
Date: 03/17/05
- Next message: Richard Caruana: "Re: How to re-populate DBgrid after doing a search"
- Previous message: Barak zabari: "Re: How to re-populate DBgrid after doing a search"
- In reply to: Oliver Tse: "Building master detail relationship"
- Next in thread: Del M: "Re: Building master detail relationship"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 17 Mar 2005 10:50:15 +0200
What error message?
For me this work
Qry1.sql.add('select * from table1')
Qry2.Sql.add('Select * from Table2')
Qry2.Sql.add(Where OEB01= :OEA01')
and set qry2.datasource = datasource1
"Oliver Tse" <news@olivertse.com> wrote in message
news:42393370@newsgroups.borland.com...
> I have two ADOQuery.
>
> query1 with datasource1 has fields:
> OEA01, .......
>
> query2 has fields:
> OEB01, ......
>
> where OEA01 = OEB01.
>
> The SQL string in the query2 is:
> Select * from table2 where OEB01 = :OEA01
>
> I set the datasouce property of 2nd query to datasource1. I open the 1st
> query is OK. When I tried to open the 2nd query, a error message was
showed
> and the 2nd query could not be open.
>
> Anybody can help me to solve this problem?
>
> Thank you
>
> Oliver Tse
>
>
- Next message: Richard Caruana: "Re: How to re-populate DBgrid after doing a search"
- Previous message: Barak zabari: "Re: How to re-populate DBgrid after doing a search"
- In reply to: Oliver Tse: "Building master detail relationship"
- Next in thread: Del M: "Re: Building master detail relationship"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
