I am getting error code 3134 with the following INSERT statement:
If rst2!DED_RT_AMT 0 Then
mSQL = "INSERT INTO DELTEK_EMPL_DED_TEST "
mSQL = mSQL & "([EMPL_ID],"
mSQL = mSQL & "[DED_CD],"
mSQL = mSQL & "[S_DED_MTHD_CD],"
mSQL = mSQL & "[DED_RT_AMT],"
mSQL = mSQL & "[DED_ANN_CEIL_AMT],"
mSQL = mSQL & "[DED_PRIORITY_NO],"
mSQL = mSQL & "[DED_START_DT],"
mSQL = mSQL & "[MODIFIED_BY],"
mSQL = mSQL & "[TIME_STAMP],"
mSQL = mSQL & "[ROWVERSION)] "
mSQL = mSQL & "VALUES ('" & rst2!EMPL_ID & "',"
mSQL = mSQL & "'" & rst2!DED_CD & "',"
mSQL = mSQL & "'PCTGRS',"
mSQL = mSQL & rst2!DED_RT_AMT & ","
mSQL = mSQL & mCeiling & ","
mSQL = mSQL & mPriority & ","
mSQL = mSQL & "#" & Format(mDED_START_DT, "d-mmm-yyyy") &
"#,"
mSQL = mSQL & "'" & rst2!MODIFIED_BY & "',"
mSQL = mSQL & "#" & mTimeStamp & "#,"
mSQL = mSQL & 0 & ")"
a.writeline (mSQL)
a.Close
db.Execute mSQL, dbFailOnError
End If
I am reading an Access table and writing to an Oracle database. Don't
see any syntax errors. I suspect the date fields might be the
problem.
Thanks!
Ken