Messages

1

Suggestions and Requests / Importing .ASPX files and webSiteMap

« on: May 07, 2007, 06:17:39 am »

Importing .CS (C#) files is sweet, but when the system runs off webSiteMap and Asp:Controls -- sucking in code leaves a lot of information out.

I would love to see User Interfaces generated from AspX files etc.


Any current suggestions?

2

Suggestions and Requests / Re: SQLSchema to XML Schema

« on: June 23, 2006, 12:12:48 pm »

What I see in the export is this:

<xs:complexType name="CONSTIT_ADDRESS_PHONES">
<xs:sequence>
<xs:element name="CONSTITADDRESSPHONESID" type="xs:int"/>
<xs:element name="CONSTITADDRESSID" type="xs:int"/>
<xs:element name="PHONESID" type="xs:int"/>
<xs:element name="SEQUENCE" type="xs:int"/>
<xs:element name="IMPORT_ID" type="xs:string"/>
<xs:element name="PK__CONSTIT_ADDRESS__75A278F5" type="CONSTIT_ADDRESS"/>
<xs:element name="PK__PHONES__1CFC3D38" type="PHONES"/>
</xs:sequence>
</xs:complexType>

The SQL is:

CREATE TABLE [CONSTIT_ADDRESS_PHONES] (
[CONSTITADDRESSPHONESID] [int] IDENTITY (1, 1) NOT NULL ,
[CONSTITADDRESSID] [int] NOT NULL ,
[PHONESID] [int] NOT NULL ,
[SEQUENCE] [int] NULL ,
[IMPORT_ID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
PRIMARY KEY  CLUSTERED
(
[CONSTITADDRESSPHONESID]
) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
CONSTRAINT [FK_CONSTIT_ADDRESS_PHONES_1] FOREIGN KEY
(
[CONSTITADDRESSID]
) REFERENCES [CONSTIT_ADDRESS] (
[ID]
) ON DELETE CASCADE ,
CONSTRAINT [FK_CONSTIT_ADDRESS_PHONES_2] FOREIGN KEY
(
[PHONESID]
) REFERENCES [PHONES] (
[PHONESID]
)
) ON [PRIMARY]
GO

<xs:element name="PK__CONSTIT_ADDRESS__75A278F5" type="CONSTIT_ADDRESS"/>

does not capture...

[FK_CONSTIT_ADDRESS_PHONES_1] FOREIGN KEY
(
[CONSTITADDRESSID]
) REFERENCES [CONSTIT_ADDRESS] (
[ID]
) ON DELETE CASCADE

3

Suggestions and Requests / SQLSchema to XML Schema

« on: June 23, 2006, 10:20:41 am »

It may already be somewhere in the product
but  under Project/ Database Engineering , I would love to see 'Generate Xml Schema'.

I'm hitting several projects where artifact or reference systems are needing to re-engineered with XML being the franca-lingua for analysis (i.e. standards that wish to be conformed to is in XML Schemas).

Having everything in the same format(XML Schema) would greatly speed the process - Especially if it handles two pass, the first pass gets the data, then the ability to mark certain tables used for FK as enumerations.

4

Automation Interface, Add-Ins and Tools / Getting EA_MenuClick error using ICONIX Addin

« on: May 28, 2007, 01:43:06 pm »

"An error occured while attempting to communicate with an Addin:

IconixAgile(IconixAgile.IconixAgileDev)

"EA_MenuClick: Invalid parent for Note (Package)"

Please contact the add-in provider for assistance.
--------------------------
Any explanations or suggestions. I just downloaded the addin last week