Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Bill Egge

Pages: [1] 2 3 4
1
I get the following error every-time I edit something - I am the only user. The project is a brand new SQL Server Database created using the 1220 scripts.

"Warning: Diagram has possibly been modified by another user."

I searched the forum and found 3 threads but no solutions.

I am using SQL Server 2014 (12.0.2254).  The only defaults I changed on the database were Recovery Mode to Simple and Auto Shrink to True.
ODBC Driver is SQL Server Native Client 11.0
Database and ODBC name has an underscore in it, problem?  "EA_EGC"

EA Version 13.0.1307
License is Corporate

2
I tried to import a large amount of Delphi source code and EA failed to import any units that contained generics or anonymous methods.

Is there anything I can do to import my source code, or am I just out of luck since generics do not seem to have a place in UML?


3
Bugs and Issues / Imported View has Top part missing
« on: December 04, 2016, 05:41:24 am »
Anyone else having this issue?  I am using SQL Server 2005 and imported a database and some imported views have a few first lines missing.  Others imported ok.

Example

SQL Server Correct Definition
Code: [Select]
ALTER view [dbo].[vHE_NextFilesToSend]
as
with Loaded as
(
  select
    distinct
    [Partner],
    DepositDate
  from
    HealthEquity_DeductionFile
),
NotSent as (
  select
    L.*
  from
    Loaded L
  where
    (not exists (
      select
        *
      from
        HealthEquity_Log X
      where
        (X.[Partner] = L.[Partner])
        and (X.DepositDate = L.DepositDate)
    ))
)
select
  [Partner],
  Min(DepositDate) as DepositDate
from
  NotSent
group by
  [Partner]


EA Imported Definition
Code: [Select]
CREATE VIEW [dbo].[vHE_NextFilesToSend] AS
(
  select
    L.*
  from
    Loaded L
  where
    (not exists (
      select
        *
      from
        HealthEquity_Log X
      where
        (X.[Partner] = L.[Partner])
        and (X.DepositDate = L.DepositDate)
    ))
)
select
  [Partner],
  Min(DepositDate) as DepositDate
from
  NotSent
group by
  [Partner]



Here are the tables if you want to test this

[HealthEquity_Log]
Code: [Select]
CREATE TABLE [dbo].[HealthEquity_Log](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Partner] [varchar](50) NULL,
[DepositDate] [datetime] NULL,
[ts] [datetime] NULL DEFAULT (getdate())
) ON [PRIMARY]

[HealthEquity_DeductionFile]
Code: [Select]
CREATE TABLE [dbo].[HealthEquity_DeductionFile](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Partner] [varchar](50) NOT NULL,
[SS_Alpha] [varchar](11) NOT NULL,
[DepositDate] [datetime] NOT NULL,
[ContributionType] [varchar](2) NOT NULL,
[clientId] [varchar](50) NULL,
[VoucherId] [varchar](50) NULL,
[Amount] [decimal](18, 2) NULL,
[MemberFirstName] [varchar](50) NULL,
[MemberLastName] [varchar](50) NULL,
[EmployeeId] [varchar](50) NULL,
[ts] [datetime] NULL CONSTRAINT [DF_HealthEquity_DeductionFile_ts]  DEFAULT (getdate()),
 CONSTRAINT [PK__HealthEquity_Ded__01142BA1] PRIMARY KEY CLUSTERED
(
[Partner] ASC,
[SS_Alpha] ASC,
[DepositDate] ASC,
[ContributionType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

4
When develop stored procedures, views, functions in SQL Management studio I am able to execute and test and so on.  Is this possible in EA such that I do not have to touch SQL Management studio.  I like the idea of editing functions straight from the diagram because it helps me keep track of things and keep my eye on the high level.  I wish it were possible, maybe it is?


5
General Board / MDA WSDL Transformation to DDL makes Class data types
« on: September 13, 2016, 05:03:05 am »
The below table was created by EA from a WSDL.  Note the "PostalAddress" type.  What can I do?

CREATE TABLE [Addressinfo]
(
   [Altaddress] PostalAddress NULL,
   [Checksum] string NULL,
   [Homeaddress] PostalAddress NULL,
   [Homegeocode] string NULL,
   [W2address] PostalAddress NULL,
   [AddressinfoID] Integer NOT NULL
)

6
Uml Process / Modeling shared sequences in Communication Diagram?
« on: July 03, 2016, 02:57:29 am »
How can I model this communication sequence without duplicating flows.

I have a WINDOW, APPLICATION, and MANAGER.

1)
When the APPLICATION shuts down then it calls WINDOW.Destroy. (This is out of my hands)
When the WINDOW is destroyed, it calls MANAGER.RemoveWindow

2)
When a WINDOW is closed by user (Window is not destroyed), the WINDOW sends a message to MANAGER.DeactivateWindow.
When MANAGER.DeactivateWindow sees that all windows are closed then it calls WINDOW.Destroy.

Thus the problem, APPLICATION.Shutdown and MANAGER.DeactivateWindow both call WINDOW.Destroy but WINDOW Destroy only has one message to MANAGER.RemoveWindow.

I need to see all possible paths that can destroy a window.  Do I have to create 2 identical messages going from WINDOW.Destroy to MANAGER.RemoveWindow, or is there a way that WINDOW.Destroy can simply display all sequences automatically?

This problem exists in any software system, such as change notifications.  In general, multiple in but 1 out.  I still want to see all the possible paths but I don't want to have go and duplicate everything when one more sequence is added.  It is unmanageable.


7
Suggestions and Requests / Replacement for Case Complete
« on: November 21, 2015, 02:22:40 am »
Add Use cases (not just the UML) to replace the need for CaseComplete. (http://casecomplete.com/)

8
Suggestions and Requests / Look of EA6 button bars
« on: November 16, 2005, 05:27:40 am »
I don't like the new rounded button bars.  It would be nice for me if I could change them to flat.


9
Suggestions and Requests / EA as an app builder
« on: August 22, 2005, 09:52:52 am »
I would like to build, debug, and step through code from EA.

I would like EA to be linked with Borland Delphi.  I would like to define my code in <actions> within class methods and then be able to step through the execution of that code directly in the model.  For instance, an action might have a green border around it to indicate the point of execution.


I would then be designing and writting my code from with EA.


I like this because EA makes seeing the application easier than looking at units of code.


10
Suggestions and Requests / Changing Monitors
« on: April 29, 2005, 06:00:17 am »
I would like a button or some way in EA to make the app relocate to another monitor and relocate all its dialogs and windows also.

The relocation would work like this in a 2 monitor system and assuming EA is currently on monitor A:
I click button X (or hot key, or menu)
The EA window relocates to Monitor B
Each dialog or window swaps its location, meaning if it were on A then it moves to B and if it were on B then it moves to A.

Essentially, every dialoag and window, including the main EA window swaps monitors.


11
Currently it seems that the dialogs such as the attribute and class editors pop up at the last location you had them.

I run dual monitors and sometimes I run EA on a different monitor.  When I do this, the dialogs pop up on the previous monitor rather than the monitor EA is running on.  I then start moving them.

My request is that the dialogs remember their coordinates relative to the EA window rather than absolute screen coordinates.



12
Suggestions and Requests / Showing only certain columns in tables
« on: April 07, 2005, 08:01:57 am »
I have a diagram with some tables.  These tables contain many columns, some with 100+ columns.  These columns show up in the diagram >:(, but for this particular diagram I only want to show relavant columns ::).

I would like to choose which columns to display.

I noticed another post where someone wanted to hide columns.   For my implementation, I would prefer the opposite method of hiding.  Not by telling the program which columns "not" to show, but which columns "to" show.

Also I saw that the method of hiding columns was by absraction or classification (steriotype, public, private, etc).  I do not desire to show columns by a classification but by each instance.

-Bill


13
Suggestions and Requests / Pervasive DB import
« on: April 06, 2005, 08:37:32 am »
I have a pervasive database and when I use the Reverse Engineering feature, all columns have the datatype "varchar".

What do I do to make it import correctly?

14
General Board / Export DDL to different DBMS?
« on: November 24, 2015, 01:33:43 am »
Is it possible to convert a database model from one DBMS to a different one?

I have imported a table structure from Pervasive and would like to generate a SQL Server version of it.  If I try to generate the DDL I get an error saying "Pervasive.SQL" does not exist or something like that even though I setup the project and imported as SQL Server 2012.

15
General Board / Detect changes in views
« on: November 21, 2015, 01:58:16 am »
In the database compare, how can I detect changes in Views where only the internals of the view have changed but columns are the same?

PS - this is a change made in the database and not in the model.

Pages: [1] 2 3 4