Generated SQL contains underscorces instead of spaces on Windows
----------------------------------------------------------------
Key: WOL-768
URL: http://issues.objectstyle.org/jira/browse/WOL-768
Project: WOProject/WOLips
Issue Type: Bug
Components: wolips
Affects Versions: WOLips 3.3.* Next Stable Build
Environment: 3.3.5049
Reporter: John Huss
Priority: Minor
In Windows, when you click Generate SQL in Entity Modeler, the sql contains underscores in some places where it should have spaces. For example:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, LOCKING PESSIMISTIC;
-- The 'Drop Primary Key Support' option is unavailable.;
DROP TABLE "Product" CASCADE;
CREATE TABLE "Product" (
"name" VARCHAR(50) CONSTRAINT NOT_NULL_Product__name NOT NULL,
"price" NUMERIC(8,2) CONSTRAINT NOT_NULL_Product__price NOT NULL,
"productID" INTEGER CONSTRAINT NOT_NULL_Product__productID NOT NULL
);
SET UNIQUE = 1000000 FOR "Product";
ALTER TABLE "PRODUCT" ADD CONSTRAINT PRIMARY_KEY_Product_productID PRIMARY KEY ("PRODUCTID") NOT DEFERRABLE INITIALLY IMMEDIATE;
COMMIT;
This is with FrontBase and WO 5.3. Strangely, when you click the button to Execute SQL it works correctly, it's just the display that is wrong.
-- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.objectstyle.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Tue Apr 01 2008 - 21:03:26 EDT