google-code-export / ords

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

Problem when editing primary key field #557

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
This one was reported by Pamela Stanworth...

What steps will reproduce the problem?
1. I created a database. I created a table. It offered me a primary key called 
"id", so I used "Edit Field" to rename it BranchID (because this is a table 
listing branches). Then I created more fields. 
2. When I tried to Save the database, I got an error message about Did you 
define a column or table name with a space or special character (but I hadn't). 
It said that the command being run (that has the problem) is CREATE TABLE.
3. Thinking that the problem might concern my primary key field, I removed the 
primary key setting on the BranchID field. Then it saved successfully.
But I would like some primary keys in my tables.

What is the expected output? What do you see instead?
It sounds as though the problem lies in renaming primary key fields, or 
possibly some general issues with saving a field that is a primary key. As 
Pamela says, this shouldn't be a problem.

Please use labels and text to provide additional information.
This is a 1.0.5 issue. Not sure which browser is being used.

Original issue reported on code.google.com by jajwil...@gmail.com on 3 Nov 2014 at 10:50

GoogleCodeExporter commented 9 years ago
This issue is no longer relevant due to the changes to Schema Designer.

Original comment by marxjohn...@gmail.com on 4 Dec 2014 at 11:39