I want to run the following sql query on the push of a button but I am not sure how to do it with Component Scripting.
update
Thermoplastics.dbo.FinishingResults
set
Thermoplastics.dbo.FinishingResults.BushingContainer = Thermoplastics.dbo.Curelot.BushingsContainer,
Thermoplastics.dbo.FinishingResults.AdhesiveContainer = Thermoplastics.dbo.Curelot.AdhesiveContainer,
Thermoplastics.dbo.FinishingResults.CureLot = Thermoplastics.dbo.Curelot.CureLot
from
Thermoplastics.dbo.CureLot
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = [Thermoplastics].[dbo].[CureLot].Container