How to retrieve the maximum value from the primary key?
I am trying to create a function that gets the maximum value from an MS Access database record. I am creating a small jsp application to work with MS Access. I am using a prepared statement something like this; "Select Max(table.id) from table". I cannot seem to figure out how to get the result value.
Any help is greatly appreciated, thanks all.