Using ADO.NET to run an Insert query on an Access database from a web
page. It complains "System.Data.OleDb.OleDbException: Undefined
function 'nz' in expression" when it gets to ExecuteNonQuery(), but
there is no Nz being used.
Here is the basic code:
strtest = "INSERT INTO Tests_Log ( test_id, log_id, time_duration,
unit_id, log_note ) SELECT Tests.test_id, NextTestLogID.nextlog_id, 10
AS Duration, 1 AS LogIntervalUnit, "test" AS Comments FROM Tests INNER
JOIN NextTestLogID ON Tests.test_id = NextTestLogID.test_id WHERE
(((Tests.test_id)=10))"
dbcomm = New OleDbCommand(strtest,dbconn)
dbread = dbcomm.ExecuteNonQuery()
Any suggestions appreciated. Thanks!