Convert to SQL

[SAMS]

Hi guys, is there a way to convert the below statement into a SQL update statement??
As when i tried to lump the two of the same kind .
The system give me this error message " Insufficient key information for updating or refreshing."

(SQL for adodc1 : SELECT export_comp.*, FEE_SC.* FROM FEE_SC, export_comp WHERE export_comp.VEND_ID = FEE_SC.VENID and Export_comp.PROCCODE = FEE_SC.FEESC )

With Adodc1

.Recordset.MoveFirst
While (Not .Recordset.EOF)
.Recordset.UpdateBatch
.Recordset!mk = Text2.Text + Val(Text1.Text) / 100
.Recordset.Update
.Recordset.MoveNext

Wend
End With

Thks

[This message has been edited by SAMS (edited 10-25-1999).]

[JHausmann]

What table does the field 'mk' belong to?

[SAMS]

mk belong to 'export_claim' table.

[This message has been edited by SAMS (edited 10-25-1999).]

[Clunietp]

I don't believe you can update a joined query, you need to update the tables separately.

Tom

------------------
[email protected]
[qualifications and/or certifications here]

[JHausmann]

give the following code a shot (you're gonna have to work with it on the where conditions to make sure it updates the right stuff):

 
dim sSQL    as string

sSQL = "update export_claim set mk =" & 
Text2.Text + Val(Text1.Text) / 100 &
"WHERE selection criteria"
database.execute sSQL

[SAMS]

Thks, JHausmann and Clunietp. I will tried on that.