Recent Posts

11

Automation Interface, Add-Ins and Tools / Re: Help changing Parent on an attribute from one class to another

« Last post by ejafman on March 28, 2026, 12:12:28 am »

curious...if I do actually use the rep.execute method, should I still run a refresh on the old and new class? I am checking the data in the actual underlying tables, and actually don't see anything that would actually need refreshing.

UPDATE...I ran a test, and debugged. My actual hardcoded update statement did work, and then ran an update(),  and the Object_ID for the row in t_attribute flipped back to the original class.

Weird, or am I not getting it?

E

12

Automation Interface, Add-Ins and Tools / Re: Help changing Parent on an attribute from one class to another

« Last post by ejafman on March 27, 2026, 10:31:55 pm »

good to know...I will see if that is possible.

Thanks

13

General Board / Re: Access sql queries from script

« Last post by amacara1 on March 27, 2026, 03:10:40 am »

Thank you. indeed, is a no go

14

General Board / Re: Access sql queries from script

« Last post by Geert Bellekens on March 27, 2026, 02:42:30 am »

Thanks! I would like to avoid duplicating the query, if possible.
If it is stored internally in EA, where would I find that, please?

IIRC the t_document table. But it's in a compressed binary format.

Geert

15

General Board / Re: Access sql queries from script

« Last post by amacara1 on March 27, 2026, 02:16:00 am »

Thanks! I would like to avoid duplicating the query, if possible.
If it is stored internally in EA, where would I find that, please?

16

Automation Interface, Add-Ins and Tools / Re: Help changing Parent on an attribute from one class to another

« Last post by Geert Bellekens on March 27, 2026, 02:05:39 am »

Thanks...I was afraid of that.

Unfortunately, I do not have update rights in the actual DB itself, so don't think I could run an update SQL statement, I believe.

Thanks for the quick answers.

Eric

Repository.Execute uses the connection EA makes to the database.
If the user that EA uses has update rights it will work.

Geert

17

General Board / Re: Access sql queries from script

« Last post by Geert Bellekens on March 27, 2026, 02:03:07 am »

The query is stored in the MDG xml, which, depending on the way the MDG is deployed is stored as a file, or internally in EA.
You would need to parse the xml and get that search string.

I'm pretty sure it's going to be easier to hardcode the query in your script.

Geert

18

General Board / Access sql queries from script

« Last post by amacara1 on March 26, 2026, 11:12:18 pm »

I have a number of sql queries imported in a model from an MDG. I would like to run such an sql query from a JScript. How can one find the string from stored sql queries, please?

19

Automation Interface, Add-Ins and Tools / Re: Help changing Parent on an attribute from one class to another

« Last post by ejafman on March 26, 2026, 08:55:53 pm »

Thanks...I was afraid of that.

Unfortunately, I do not have update rights in the actual DB itself, so don't think I could run an update SQL statement, I believe.

Thanks for the quick answers.

Eric

20

Bugs and Issues / Re: CSV export of smart quotation becomes ’

« Last post by Sunshine on March 26, 2026, 06:32:45 pm »

I reported this as a bug some time ago but never got a response. Support has gone down hill over the years as I used to get an acknowledgement as to whether it was a bug and a work around within a day.
The easiest thing I can suggest as a work around is to do a search and replace in the CSV file with excel.
Noting that is only one of many characters that get corrupted during export to UTF-8 from Windows 1252 the default character set for Windows.

Another option in the Notes editor, avoid using:
- Smart quotes
- Bulleted lists
- Special symbols (•, –, …)
You can do this by not copying and pasting from word but paste into notepad then copy from notepad.