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.

Messages - hd

Pages: [1] 2 3 ... 21
Upgrade to EA version 13.5?

General Board / Re: Querying multiple optional tag values in SQLServer
« on: April 13, 2018, 07:52:33 am »
Aliases are wrong?

tv1.Value AS tv1,
tv2.Value AS tv1,
tv3.Value AS tv1,

should be...
tv1.Value AS tv1,
tv2.Value AS tv2,
tv3.Value AS tv3,

General Board / Re: XMI import problem
« on: February 23, 2018, 02:51:55 pm »
I think you'll find the key in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\...

General Board / Re: Reverse Engineering a MySql db (RDS on AWS)
« on: January 17, 2018, 12:42:33 pm »
Are you using the 32-bit MySQL ODB Driver?  See the first Note at the bottom of page...

Diagram Properties | Elements | Show Compartments - disable Attributes.

General Board / Re: Database Builder: More than on connection
« on: June 09, 2017, 07:36:02 am »
No.  The Database Builder can only compare an EA data model with a live database...

Maybe you are using a 64-bit Oracle client.  EA only works with 32-bit clients.

General Board / Re: int, identity column
« on: March 29, 2017, 07:43:53 am »
Select your table in the Database Builder, select your identity column, set AutoNum to true in column properties list at lower left.

General Board / Re: Glossary Export?
« on: March 01, 2017, 07:38:46 am »
Ribbon > Start > Search > Search in Model.  Third icon after the Go arrow to get to the SQL Scratch Pad.

As well as replacing the square brackets with double quotes, CONCAT could also be the problem. Maybe ...
Code: [Select]
SELECT CONCAT(t_object.ea_guid, t_object.Name)or...
Code: [Select]
SELECT t_object.ea_guid || t_object.Nameor...
Code: [Select]
SELECT t_object.ea_guid, t_object.Name

General Board / Re: Upgrade to 13 with Postgres db
« on: December 07, 2016, 07:33:19 am »

Grant users ALTER permission on the t_image table...
Code: [Select]
GRANT ALTER ON [dbo].[t_image] TO <eauser>;
Image IDs are unique, t_image.ImageID is an IDENTITY column, and inserting an image into the t_image table therefore requires execution of SET IDENTITY_INSERT t_image ON/OFF, which requires ALTER permission on the table.

Pages: [1] 2 3 ... 21