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
SetFillColor(c); DrawNativeShape(); usually fills elements with the specified color. Not so for boundaries. Obviously the default "No fill" for boundaries prevents coloring. So, what needs to be set in the metaclass to create a filled boundary that will take the supplied color?

q.

2
General Board / Re: How do I generate unique IDs for design elements?
« on: August 23, 2019, 09:38:21 pm »
FWIW, this functionality renders useless in practical use: If you have multiple editors with (version) controlled packages each one has its own counter. Even if you manage to have all to use the same setting, the counter can not be synched. It more or less only works for a central database.

Also: why have such a numbering scheme for classes? Someone out there to go with a class model with numbered classes? Or Actions? Or anything else (except requirements and issues)?

q.

3
General Board / Re: Any tips for migrating to a new computer?
« on: August 23, 2019, 03:13:42 am »
I guess not. But I'd do the following: install EA on the new machine. Rename the installation folder to EANew or whatever. Zip/unzip the program folder from the old machine to the new. Export/import the registry HKEY_CURRENT_USER\Software\Sparx Systems. Copy whatever EAP you have. %appdata%/..sparx.. should be copied as well. If you now start EA on the new machine it should be a copy of your old one.

q.

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

q.

5
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.

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

q.

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

q.

8
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.

9
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.

10
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.

11
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.

12
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.

13
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.

14
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.

15
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.

Pages: [1] 2 3 ... 694