Updating a multi table SQL view through asp...
Posted on 2005-05-12
Hello all I have a question. I have a 2 table view that I need to update on my web pages. Table1 and Table2 linked through key ID in Table1 to key ClientID in Table2. I am using ADODB connection and this is my connection string:
strSQL = "SELECT * FROM vw_clients WHERE ID = '" & recordID & "';"
rstcontacts.Open strSQL, cnnLogin, adOpenKeyset, adLockPessimistic, adCmdText
I am passing values to the fields in the view and then I do a .update but I get an error message stating:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot insert or update columns from multiple tables.
Why is this happening? I can edit and insert into the view using Enterprise Manager and get no errors.
This question is worth 500 points since I need a quick fix.