Re: Insert, Update and Delete with Join Tables
- From: "Del M" <Del.Murray@xxxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 22:28:41 -0400
TADOQuery.Properties['Unique Table'].Value:='table1'
Then only table1 columns will be updated.
"Alejandro Genovesi" <alejandro.genovesi@xxxxxxxxxxxxxx> wrote in message
news:4267f6fe@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi, all
>
> I've a TADOQuery with this SQL property:
>
> Select Table1.code,
> Table1.status ,
> Table2.Name,
> Table2.age
> From Table1
> join Table2 on table1.code = table2.code
>
> .....
>
> If I try to do
>
> with ADOQuery1 do begin
> Active; := True;
> Edit;
> FieldByName ('Name') := 'xxx';
> Post;
> end;
>
> I've an error.
>
> How I can to Update o Insert with join tables?
>
> Thank you
>
>
> AD
>
>
.
- Follow-Ups:
- Re: Insert, Update and Delete with Join Tables
- From: Brian Bushay TeamB
- Re: Insert, Update and Delete with Join Tables
- References:
- Insert, Update and Delete with Join Tables
- From: Alejandro Genovesi
- Insert, Update and Delete with Join Tables
- Prev by Date: Re: Is there any AS400 free Driver
- Next by Date: Re: ADO Deployment
- Previous by thread: Re: Insert, Update and Delete with Join Tables
- Next by thread: Re: Insert, Update and Delete with Join Tables
- Index(es):
Relevant Pages
|
