Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Visual Editing |
| Version | Future - .3 |
Version: 13.0-dev-14
Build #: 30127
Build Date: 2012-Nov-09 03:59:50 PM
1. Created a table in SQLite with the below DDL
CREATE TABLE "Order Details" (
"OrderID" INTEGER NOT NULL,
"ProductID" INTEGER NOT NULL,
"UnitPrice" NUMERIC NOT NULL DEFAULT 0,
"Quantity" INTEGER NOT NULL DEFAULT 1,
"Discount" REAL NOT NULL DEFAULT 0,
PRIMARY KEY("OrderID","ProductID")
)
GO
2. Selected Alter Table
3. Go to the Constraint tab
4. Right click on Primary key and you get a menu as attached which has no action
|
|
27 KB
SQLite doesn't have "ALTER TABLE ADD CONSTRAINT" or "ALTER TABLE DELETE CONSTRAINT" support. Therefore, the Constraint tab for Alter Table is read only.
The Table Dialog displays the popup menu, but there is no effect on any action. This is the intended behavior.
This might create a little bit of confusion to user. In AD Studio we rarely display popups which does not have any action.
Can you check with Niels ?
This might create a little bit of confusion to user. In AD Studio we rarely display popups which does not have any action.
Can you check with Niels ?
See TableDialog.Line-321. I just need to have a condition for these support options.
See TableDialog.Line-321. I just need to have a condition for these support options.
Issue #7942 |
| Closed |
| Incomplete |
Completion |
| No due date |
| No fixed build |
| No time estimate |
SQLite doesn't have "ALTER TABLE ADD CONSTRAINT" or "ALTER TABLE DELETE CONSTRAINT" support. Therefore, the Constraint tab for Alter Table is read only.
The Table Dialog displays the popup menu, but there is no effect on any action. This is the intended behavior.