
AddNew into updatable join ?
I don't think you can add new records into multiple database tables
when the data is retrieved through a join statement. You can only add
records into a single table at a time.
Kirk Allen Evans
Quote:
> Has anyone any tips on inserting into a joined SQL with ADODC ?
> I have an udatable Query (Table1 LEFT JOIN ON table 2) attached via
> an ADODC Control.
> When I do an .AddNew, I run into trouble with the right side of my
> join. The edits don't seem to be saved.
> I have a trigger that creates the appropriate record in Table 2 when
> an Insert into Table 1 happens.
> I can get around this by using SQL to insert the record & then
> refreshing the entire ADODC, but this is very slow
> Any suggestions on how to do this with out a refresh ?
> ---------------------------------------------------------------
> Dr. Bill Honey I.T. Consultant
> Collage Consulting Ltd.
> Tel 0973 837620
> ---------------------------------------------------------------
--
Kirk Allen Evans
(Do not send mail to the Deja News account used
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.