Expand|Select|Wrap|Line Numbers
- strSQL = " SELECT HYDRO.SITECHECKS.*, HYDRO.SITES.SITE_NAME, HYDRO.MEASURANDS.MEASURAND" & _
- " FROM (HYDRO.SITES INNER JOIN HYDRO.SITECHECKS ON HYDRO.SITES.SITEID = HYDRO.SITECHECKS.SITEID) " & _
- " INNER JOIN HYDRO.MEASURANDS ON HYDRO.SITECHECKS.MEASURANDID = HYDRO.MEASURANDS.MEASURANDID " & _
- " WHERE HYDRO.SITECHECKS.MEASURANDID=" & MEASURAND & " ORDER BY HYDRO.SITECHECKS.SITEID"
The message I am receiving is 'The recordset is not updatable'. The same things works using linked tables but not using connection string with MSDAORA.
Can you please help me so that I can add data to SITECHECKS table using MASTER CHILD form.
Thanks in advance