Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: tzafrir on January 24, 2017, 06:22:49 am
-
Is there an API that can do a direct update on data on DB?
-
Repository.Execute
You should not use it except you like juggling with bombshells.
q.
-
Repository.Execute
You should not use it except you like juggling with bombshells.
q.
I must like juggling with bombshells then :P
No, in all seriousness, you should only ever use it if there is no viable alternative. But there are a number of cases where I had to use this as a last resort, either because the thing I was looking for wasn't exposed in the API, or in cases of mass updates where using the API would mean hours of runtime against half a second when using a direct SQL update statement.
Geert
-
Hello,
Refer this
http://sparxsystems.com/forums/smf/index.php/topic,26576.msg207074.html#msg207074
Hope this helps
BR
Nabil
-
Thanks all,
I need it for the following case:
When entering notes in Hebrew
The API of notes will return the value:
Notes + DB = "מודל ה"
And it put the value Left To Right
When using CtrlShift it does move it to the right and change the DB as follows:
<p align="right" dir="rtl"><span dir="rtl">מודל</span><span dir="rtl">ה</span></p>
Do you think there is other way besides intervention with an update statement to get that result without manual touch?
-
Sorry, but I can't follow your steps. What does Ctrl-Shift do? And what is "it" doing the RTL? Maybe you list the steps in some order one can follow?
q.
-
If you are assigning to the notes, just wrap any paragraphs you want right to left with <p align="right" dir="rtl"><span dir="rtl"> and </span></p>.
If you can construct that string it's no harder to assign it using the API than through SQL.