Tim,

I am attempting to convert my final form from EWB2 to EWB3.

The StockStockFields, StockOptions datasets have edit grids with a dataset tool bar that has Append, Delete, Edit, Update and Save buttons.

The Enabled property for these buttons are initially set to false. There is no code in the project that adjusts the Enabled property. Other forms automatically adjust the Enabled property but not this form. The buttons are always NOT enabled.

The form does not allow the grid to extend to the row below the last row to add another.

I have deleted the source files for the form and reconstructed the form. The form file and the source files look the same to me as the other forms that work.

I have also deleted the datasets from the database manager and re-entered the details.

Any ideas as to what can be stopping the Enabled property to be changed?


CREATE TABLE "StockCategories"
(
"ID" VARCHAR(3) COLLATE "ANSI_CI",
"Name" VARCHAR(16) COLLATE "ANSI_CI" NOT NULL,
CONSTRAINT "scPrimaryIND" PRIMARY KEY ("ID"),
CONSTRAINT "scCheckForSlash" CHECK (OCCURS ('/' IN ID) = 0)
ERROR CODE 28104 MESSAGE 'Category cannot contain a slash'
)

CREATE TABLE "StockFields"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"StockCategory" VARCHAR(3) COLLATE "ANSI_CI" NOT NULL,
"FieldName" VARCHAR(16) COLLATE "ANSI_CI" NOT NULL,
-- More columns

CONSTRAINT "sfPrimaryIND" PRIMARY KEY ("ID"),
CONSTRAINT "sfCategoryFK" FOREIGN KEY ("StockCategory") REFERENCES "StockCategories" ("ID")
  ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT "sfFieldNameUNQ" UNIQUE ("StockCategory", "FieldName")
)

CREATE TABLE "StockTypes"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"StockCategory" VARCHAR(3) COLLATE "ANSI_CI" NOT NULL,
"FieldName" VARCHAR(16) COLLATE "ANSI_CI" NOT NULL,
"Option" VARCHAR(32) COLLATE "ANSI_CI" NOT NULL,
CONSTRAINT "syPrimaryIND" PRIMARY KEY ("ID"),
CONSTRAINT "stCategoryFK" FOREIGN KEY ("StockCategory") REFERENCES "StockCategories" ("ID")
  ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT "syFieldNameFK" FOREIGN KEY ("StockCategory", "FieldName") REFERENCES "StockFields" ("StockCategory", "FieldName")
  ON UPDATE RESTRICT ON DELETE RESTRICT,
CONSTRAINT "syFieldOptionUNQ" UNIQUE ("StockCategory", "FieldName", "Option")
)

The SQL statements can all be executed from EDB Manager.

DELETE FROM "StockTypes" WHERE "ID" = :Old_ID

INSERT INTO "StockTypes" VALUES
(
:ID,
:StockCategory,
:FieldName,
:Option
)

SELECT *
FROM StockTypes
WHERE StockCategory = :Category AND FieldName = :FieldName
ORDER BY StockCategory, FieldName, "Option"

UPDATE "StockTypes" SET
"ID" = :ID,
"StockCategory" = :StockCategory,
"FieldName" = :FieldName,
"Option" = :Option
WHERE "ID" = :Old_ID

Richard

<< I am attempting to convert my final form from EWB2 to EWB3.

The StockStockFields, StockOptions datasets have edit grids with a dataset tool bar that has Append, Delete, Edit, Update and Save buttons.
>>

Tim

This was due to an error in my EWB3 application. I do not know why it worked in EWB2.

Richard