search

google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

Adding records to an ORDS table via Access messes up autonumbering if anyone then tries to add more records via the native ORDS interface #633

Open jajwilson opened 9 years ago

jajwilson commented 9 years ago

633 from Google Code.

What steps will reproduce the problem?

  1. Find an ORDS database with a table where there is an auto-numbering fields
  2. Connect to this database via ODBC from MS Access
  3. Add new records to this table, typing in consecutive ID numbers by hand in the autonumbering fields (Access does not record such fields as autonumbering, but it does spot that they require unique values)
  4. Return to the table in ORDS and try adding a new record there.

What is the expected output? What do you see instead? ORDS returns the error message: "Unable to add that record. Check the data conforms to the schema. The error was: null"

Please use labels and text to provide additional information. Chrome App 1.0.9 - 4141.

Note that in the instance that caused the error, the table in question consisted of eight records with ID numbers from 1-8. Via Access I added records with ID numbers 9, 20, and 10. The ORDS should have picked up either that the first missing consecutive number was 11, and gone with that, or picked up that the highest existing number was 20, and therefore assigned 21 to the next record added. As it is, it just seems to have got confused and thrown an error.

I'm making this Critical as the 19thC Professions Project are going to be working in this kind of multiple-editing-interface manner very soon.