VB & Database, AddNew into updatable join ?

AddNew into updatable join ?

Author	Message
Bill Hone #1 / 3	AddNew into updatable join ? 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 ---------------------------------------------------------------
Fri, 04 Jan 2002 03:00:00 GMT

Kirk Allen Evan #2 / 3	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.
Sat, 05 Jan 2002 03:00:00 GMT

Lotha #3 / 3	AddNew into updatable join ? The bottom line is that you can't update or add new records to multiple tables. The best you can do is to use a stored procedure. 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 > ---------------------------------------------------------------
Sat, 05 Jan 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]