December 6, 2003 at 12:19 am
hi all expert,
I have a recordset in which having a couple of fields, those fields are come from three table. When i try to call the recordset.update method, then i receive a error message as "Cannot insert or update column from multible table".
I've tried to create a view from enterprise manager. The view's command is exactly the same as how the recordset created. When i update the view, there is fine, but update at recordset having problem.
i'm using adodb 2.6,VB6,SQL Server 2000
Please guide
Thanks
December 6, 2003 at 2:00 am
You cannot update multiple tables in one statement. You'd need 3 statements to update all 3. You can update one table that is joined to 2 others, but the updates all must occur in one table.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
February 14, 2007 at 1:45 pm
Using a single datasource configurtaion can i put three update statements in the custom statement field?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply