SQL question - cant make UPDATE query work

[Guest srusse01]

I am trying to access an A2000 database which is running on Access 2002. I am getting the following event log, but nothing is updated to the database table. any clues?

 

111858.30 7 Going down On Success path.

111858.31 7 [update tblRand] DB Query

111858.31 7 Jet mode used (To use ODBC mode specify ODBC Connect string)

111858.31 7 RVreplace start: [uPDATE tblRand SET URNum='$RV[EnterUR]' and DteRand = $RV[Date] WHERE StudyID='$RV[GetStudyId_1_1]']

111858.33 7 RVreplace end: [uPDATE tblRand SET URNum=147' and DteRand = 23/02/2004 WHERE StudyID='612300]

111858.34 7 About to execute Action Query

[SupportTeam]

If no errors were reported then the SQL command was passed OK for execution to the database.

Maybe there was a problem with the SQL statement itself?

Are URNum and StudyID fields defined in the database as strings?

Can you try removing the "and DteRand = 23/02/2004" from the SQL statement?

[PhilRobert]

Try to put ' on each side of the date... like this:

Update blRand set DateRand='03/03/2004' where...

 

Hope it will help =)

[Guest srusse01]

I finally have this working...by separating the update into 2 modules and updating one field per module.

thanks for your help