-
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).]
-
What table does the field 'mk' belong to?
-
mk belong to 'export_claim' table.
[This message has been edited by SAMS (edited 10-25-1999).]
-
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]
-
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):
Code:
dim sSQL as string
sSQL = "update export_claim set mk =" &
Text2.Text + Val(Text1.Text) / 100 &
"WHERE selection criteria"
database.execute sSQL
-
Thks, JHausmann and Clunietp. I will tried on that.
