A (hopefully) little problem with SQL executeUpdate

Hi there,

I'm writing a very basic java database program that reads from a table in MS Access, pastes into gui text fields and allows the user to change the fields and save the changes.

The problem I think that I'm having is in the syntax of the executeUpdate statement, and I can't seem to find anything that works. What I've got is:

String update = "UPDATE CourseInfo" + " SET CourseNumber = 1204" + " WHERE CURRENT OF " + record.getCursorName();

I've also tried setting up a field named ID and using " WHERE ID = '1' " and a few other variations. Unfortunately my experience in SQL is so limited that I have utterly no idea where I'm going wrong.

The error I'm getting is : "Syntax error (missing operator) in query expression 'CURRENT OF SQL_CUR0ad7e658' ".

Any help will be much appreciated!

Thanks!

Kath

The error I'm getting is : "Syntax error (missing operator) in query expression 'CURRENT OF SQL_CUR0ad7e658'

I beleive it is telling "something wrong with following syntax: 'CURRENT OF"

Try

String update = "UPDATE CourseInfo" + " SET CourseNumber = 1204" + " WHERE EnterCousreFieldNameHere = " + record.getCursorName();

Substute "EnterCousreFieldNameHere" with actual field name

S-