Hmm... did you notice whether your Save() was working? I have a feeling it wasn't. Then when you issued the Next(), the row change implicitly tried to recommit the change (I'm assuming row buffering), and you got that error.
Either way, glad you figured it out.
---J
>Jason,
>
>Thanks for your reply. I went further with testing this outside the app and isolated the problem. The business object contains a view which I want to process one record at a time. I get the first record and issue the next method after updating a column in the view and issuing a save(). This is what seems to have caused the problem.
>
>The name of the column in the view I was updating was called 'desc' (short for description). On a hunch I changed this to something else and this stopped the syntax error from happening.
>
>I still don't know why this caused a syntax error, but I guess I should know better to name a column after a reserved word.
>
>Thanks again for your help.