Hi all,
I have the following query which I want to use to update a DataTable:
"SELECT
tblVmsResponse.IntDestZone,(tblVmsResponse.LngDest inationDiversionNum)
as Diversionnumber," & " (tblVmsResponse.strIncidentLink) as
Incidentlink ,(tblVmsResponse.bytMessageResponse) as response,
tblVmsResponse.strPlan" & " FROM (tblIncidentResponse INNER JOIN
tblVmsResponse ON
tblIncidentResponse.strLinkNum=tblVmsResponse.strI ncidentLink) INNER
JOIN" & " tblPlanVmsSetting ON tblPlanVmsSetting.strVmsId
=tblVmsResponse.strVmsId" & " WHERE ((tblVmsResponse.strVmsId = ?) AND
(tblPlanVmsSetting.strPlan =?) AND" & "
(tblPlanVmsSetting.strPlan=tblIncidentResponse.str Plan))" & " GROUP BY
tblVmsResponse.intDestZone,tblVmsResponse.LngDesti nationDiversionNum,"
& " tblVmsResponse.strIncidentLink,tblVmsResponse.bytM essageResponse,
tblVmsResponse.strPlan;"
I now want to be able to fill a DataTable and, at a later stage,
execute the above query with values for tblVmsResponse.strVmsId and
tblPlanVmsSetting.strPlan (which are currently unknown). I then want
to update the table based on the supplied values.
How can this be done?
Thanks in advance
Simon