[OS-JIRA] Created: (WOL-768) Generated SQL contains underscorces instead of spaces on Windows

From: John Huss (JIRA) ("John)
Date: Tue Apr 01 2008 - 21:02:26 EDT

  • Next message: Lachlan Deck (JIRA): "[OS-JIRA] Created: (WOL-769) html refactor behaviours"

    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