Board index » delphi » JOIN SQL, autoSQL and Delete record from this JOIN SQL

Zhu Huaiyang

Delphi Developer
Fri, 04 Jun 2004 16:15:13 GMT

JOIN SQL, autoSQL and Delete record from this JOIN SQL

I have written a SQL text into a ADOQuery:

select A.*, B.* from A
left outer join B on A.ID = B.ID

ADO can create updating, deleting and inserting SQL automatic of this
ADOQuery.
But I want to write these SQL self, How should I do?
When I use ADOQuery.Delete, it deletes two records from table A and table B,
I need only delete the record from table A, save the record in the table B,
how
to do?
I set those fields in the A to:
Field.ProviderFlag := [pfInWhere, pfUpdate];
set those fields in the B to:
Field.ProviderFlag := [];
But it is not worked.

Thank u very much.

william
Sorry for my bad English

 
Guillermo Casta?o

Delphi Developer
Fri, 04 Jun 2004 21:00:54 GMT

Re:JOIN SQL, autoSQL and Delete record from this JOIN SQL


USe
MyADOQuery.RecordSet.Properties['Unique Table'].Value :=
  'The Name of the table you want to restrict updates to' ;

Quote
Zhu Huaiyang wrote:
> I have written a SQL text into a ADOQuery:

> select A.*, B.* from A
> left outer join B on A.ID = B.ID

> ADO can create updating, deleting and inserting SQL automatic of this
> ADOQuery.
> But I want to write these SQL self, How should I do?
> When I use ADOQuery.Delete, it deletes two records from table A and table B,
> I need only delete the record from table A, save the record in the table B,
> how
> to do?
> I set those fields in the A to:
> Field.ProviderFlag := [pfInWhere, pfUpdate];
> set those fields in the B to:
> Field.ProviderFlag := [];
> But it is not worked.

> Thank u very much.

> william
> Sorry for my bad English

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com
Zhu Huaiyan

Delphi Developer
Sat, 05 Jun 2004 13:06:07 GMT

Re:JOIN SQL, autoSQL and Delete record from this JOIN SQL


Thank u very much.
I will try it

"Guillermo Casta?o A" <Guiller...@GrupoMillennium.com>
wrote:3C1DEC85.3B43E...@GrupoMillennium.com...

Quote
> USe
> MyADOQuery.RecordSet.Properties['Unique Table'].Value :=
>   'The Name of the table you want to restrict updates to' ;

> Zhu Huaiyang wrote:

> > I have written a SQL text into a ADOQuery:

> > select A.*, B.* from A
> > left outer join B on A.ID = B.ID

> > ADO can create updating, deleting and inserting SQL automatic of this
> > ADOQuery.
> > But I want to write these SQL self, How should I do?
> > When I use ADOQuery.Delete, it deletes two records from table A and
table B,
> > I need only delete the record from table A, save the record in the table
B,
> > how
> > to do?
> > I set those fields in the A to:
> > Field.ProviderFlag := [pfInWhere, pfUpdate];
> > set those fields in the B to:
> > Field.ProviderFlag := [];
> > But it is not worked.

> > Thank u very much.

> > william
> > Sorry for my bad English

> --
> Guillermo Casta?o Acevedo
> Gerente de Sistemas - Grupo Millennium Ltda
> Guiller...@GrupoMillennium.com
> www.GrupoMillennium.com

Other Threads

1. SQL Delete and Join

2. SQL DELETE and joins - how!?

3. Unknown Column error when updating records from a join SQL

4. Unknown Column error when updating records from a join SQL

5. Unknown Column error when updating records from a join SQL

6. SQL Help: inner join problems with Local SQL

7. HELP with Deleting Records in Joined Tables

8. Delete a record from a joined Query

9. ADOQuery: SQL with JOIN / UPDATE-DELETE AFFECTS JOINED TABLES - IT'S NO GOOD!

10. Inner join and left join