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 - qwerty

Pages: [1] 2 3 ... 694
1
General Board / Re: Where do I put user stories in my model?
« on: Today at 06:10:45 am »
EA is limited in showing things you want it to show. However, you have some options. A) attach a note to an element and from the link context select Link to Element Feature and there Element Note. B) for the diagram properties Elements/Notes or C) for the diagram element context menu Features/Feat...Visibility/Show Notes will show both the element notes in an element compartment.

q.

2
I wasn't talking about the generated but the source stereotype. Anyway, I don't really care.

q.

3
Some caveats with using GetActiveObject - it will attach to either the first or last instance of EA that has been started.  There is no way for a user to specify which instance to attach too - the behavior is OS/version/build dependent.  If you have multiple instances of EA started this call will give you all kinds of headaches.

Stan.
True. Though, I think that most of the users have only a single instance running. Especially in an environment with shared keys. But honestly, I had been fooled by that also in the past.

q.

4
Just wait when you switch to V15, and V16 ...

q.

5
Raises the question how stereotypes having a space inside appear in that context. Or a stereotype named "Some%20".

q.

6
General Board / Re: VBScrpt SQL Select query but SQL Update wont work.
« on: August 19, 2019, 08:46:14 am »
Yes, MSAccess is very "modest" when it comes to SQL details.

q.

7
General Board / Re: VBScrpt SQL Select query but SQL Update wont work.
« on: August 18, 2019, 02:06:11 am »
No. The scratch pad is R/O.

You could dump the SQL to text and post it as question on SO.

AFAIK Access does not like JOIN so much. Try sending it as just SELECT over the scratch pad. Probably you need to go to some WHERE/AND clause instead.

q.

8
No boolean, no procedures. Just copy and paste :-/

I made a complete (it's tiny) EBNF of shape script at the end of my shape script book.

q.

9
General Board / Re: VBScrpt SQL Select query but SQL Update wont work.
« on: August 17, 2019, 07:05:24 am »
Because you're targeting an EAP and MSAccess is not ANSI SQL compliant.

It's also a good idea to post the error that's thrown. Look into %appdata%/...sparx.../dberror.txt too.

q.

10
General Board / Re: How to retrieve the name of the last modifier
« on: August 16, 2019, 06:44:30 am »
Some more info: bincontent1 contains a zip with a single str.dat file (the usual format). For me a sample looked like this:

Code: [Select]
<LogItem><Row Number="0"><Column Name="Audit Options"><Old Value=""/><New Value="All"/></Column><appliesTo/><Column Name="Auditing"><Old Value="Disabled"/><New Value="Enabled"/></Column></Row><Details User="Thomas" DateTime="2019-08-15 22:11:47"/></LogItem>
bincontent2 of the same record had an utf8 string like

Code: [Select]
<metadata><Row Number="0" Standard="1"><Level LevelName="Audit Settings" Name="Auditing" GUID="Auditing"/></Row><Details User="Thomas" DateTime="2019-08-15 22:11:47" Standard="1"/></metadata>

I guess that will already give you the right direction.

Note that using repository.SQLQuery returns the bincontent columns as base64 encoded!

q.

P.S. I just added this to my Inside book.

11
General Board / Re: How to retrieve the name of the last modifier
« on: August 16, 2019, 06:34:01 am »
So here's a short summary:

SnapshotID: primary key
SeriesID: was just 'LOG' but will dig a bit more
Position: not unique so obviously some changes take more than one row
SnapshotName: the affected table name
Notes: see below
Style: type of update like INSERT etc.
ElementID: No idea. Was just 1 or 0. Will see.
all other columns were just not occupied. Will dig a bit more

Now for the Notes:
I had lines staring with "Audit"... which obviously told that auditing was changed
Others started with a GUID that was the element/connector(/diagram? not tested) GUID of the respective table in SnapshotName followed by mixed data.

I think the user info is stored in the bincontent columns. Need a closer look but that will take a moment.

I'll keep you posted.

q.

12
General Board / Re: How to retrieve the name of the last modifier
« on: August 16, 2019, 06:10:51 am »
I haven't covered the audit trail in my Inside book so far. I'll have a look and see what can be deciphered on short terms.

q.

13
General Board / Re: How to retrieve the name of the last modifier
« on: August 15, 2019, 07:44:46 pm »
Nope. What't lost is lost.

q.

14
Basically what others said. However, requirements are best kept in dedicated systems so I usually add a stereotype property taking the ID from that system since in most cases EA will not be able to give a consistent unique numbering for the requirements.

q.

15
General Board / Re: How to retrieve the name of the last modifier
« on: August 15, 2019, 06:20:48 pm »
There are only two ways. Either you turn on auditing or you dare to write a trigger for that purpose.

q.

Pages: [1] 2 3 ... 694