www.usoft.com To www.usoft.com

Replies posted by robert.hellinx

18 Replies

B
bert.wilms
asked in Share your best practices

Adding a default record when a another record is inserted

Dear Bert,As this is a Business Rule for your application, I would use a constraint. I formulated the Business Rule thus:"When some adds an aircraft type, a default aircraft type must be added if it is not yet available."From your SQL I assume that the primary key of Aircraft Patterns consists of the pattern ID and the version number.I also  assume you defined a relationship between Aircraft Types and Patterns, so Pattern ID and version number in Aircraft Types refer to the Patterns.Last I assume Aircraft ID completes the primary key of Aircraft Types.Because you wrote "When someone inserts a new record ..." I would make this constraint transitional:Fire on Insert: AlwaysFire on Delete: NeverFire on Update" Used columnsI quickly built a reference model. I think from there you can create a working solution for you application (I abbreviated Aircraft to AC).The constraint SQL:insert into AC_TYPE( pattern_id, version_nr, aircraft_id, aircraft_class)select acpn.pattern_id, acpn.ve

1
R
7 days ago
marc
marc
asked in Got a Question?

Export SFW server metadata (XML) in UDeliver?

Hi Marc,The easiest way is to add an action to one of your release tasks that exports all application data for the Service Definer USERVICEYou may have to add USERVICE to the list of applications first (Define – Applications):Then you can add an action to a task of your choice, I named it "Back up Repository:It requires three parameters: Application, Database account and Destination folder.  I Used the predefined Source variable "${release}" to indicate the folder "${release}\appdata". You can also use a custom folder.When you run this action you will get an XML export with all definitions from the Service Definer.Regards,Robert

2
marc
1 month ago
marc
marc
asked in Got a Question?

Updating interface components

Hi Marc,You asked about the toggling you use to see new methods in an interface. It's a feature: When you first turn an RDMI Component into an interface component, all methods of the component become interface methods. If you add a method to a component, the interface checkbox is not set automatically. You have to decide yourself if you want the method to be available in the interface.If you uncheck the Interface attribute of this component, the methods can no longer be part of an interface, so they are unchecked as well. If you check the Interface attribute of the component after that, all methods are added to the interface.See the checkboxes on the image below.A new method on a component that is part of the interfaceIf you check the checkbox at the level of the method, you don't have to toggle and the method will be available in new conceptual files.About the second question, not being able to use an RDMI component defined in another module is a bug. I created at support ticket for t

3
marc
2 months ago
M
MDC
asked in Got a Question?

Hardware and operating system requirements for USoft 10.1 and 11

Thank you for the tip. The information about USoft Developer version 10.1 has been added to the page you mentioned.( https://community.usoft.com/installing-usoft-183/hardware-and-operating-system-requirements-1095?tid=1095&fid=183 ).

1
R
3 months ago
marc
marc
asked in Got a Question?

Execute UDeliver rules service script in UBelndIt

Hi Marc,Your issue is with the Rules Engine. The Rules engine only accepts one statement at a time.The Rules engine does accept XML or JSON documents with multiple rows, but I assume your SQL statements use conditions.The Delivery Manager delivers a default deploy script for Data Definition Language. That script calls other tools in order to perform multiple statements. Is that a solution you could use? Regards,Robert

3
marc
3 months ago
MaxMallon
MaxMallon
published in XML internal component

XML.Query

fyi a working example:INVOKE XML.Query WITHSELECT 'Yes' "UseIOFormats", '<Query> <Table Name="T_DOMAIN"> <Column Name="DOMAIN_NAME" Condition="TW%" Order-by-seqno="1" Order-by-direction="DESCENDING"/> <Column Name="DATATYPE" Condition="NUMBER" Order-by-seqno="2" Order-by-direction="DESCENDING"/> </Table></Query>' "XMLDocument"Result:-----report on script no. 1<Domains documentName="Domains"><T_DOMAIN DOMAIN_NAME="TWI_INT_8" SUPER_DOMAIN="" DATATYPE="NUMBER" TOTAL_LENGTH="8" LENGTH_AFTER_PERIOD="0" F_DATATYPE="INT" F_TOTAL_LENGTH="8" F_LENGTH_AFTER_PERIOD="0" DISPLAY_LENGTH="" UPPERCASE="N" FIXED_LENGTH="N" IS_SEQNO="N" DEF_VALUE="" RANGE_LOW="" RANGE_HIGH="" HELP_TEXT="" IOFORMAT="" DBFORMAT="" DESCR="Domain is used by USoft Production." PERC_FULL="" CREATED_BY="ROBERT10 CREATED_ON=" 12-NOV-2020 10:28:43" CHANGED_BY="ROBERT10" CHANGED_ON="12-NOV-2020 10:28:43" SEQNO_COMPONENT="" INTERFACE="N" MODULE="" INTERFACE_CORRECT="Y"

521
R
6 months ago
marc
marc
asked in Got a Question?

xsl:strip-space in XSL Stylesheet component

Marc,As a workaround you could use USXSL.apply instead of a XSL component.I reproduced your error after creating a working example using USXSL.apply.You might recognize my data model in the XSLT:<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:strip-space elements="Sequence_Numbers TABLE_SEQUENCE_NUMBERS" /><xsl:template match="/"> <xsl:apply-templates/></xsl:template><xsl:template match="Sequence_Numbers/TABLE_SEQUENCE_NUMBERS"> <xsl:value-of select="@TABLE_NAME"/> <xsl:text> ( </xsl:text> <xsl:value-of select="@SEQNO"/> <xsl:text> ) </xsl:text></xsl:template> </xsl:stylesheet>Regards,Robert

2
marc
6 months ago
marc
marc
asked in Got a Question?

Delete from SQL Server without UPDLOCK

Hi Marc,When data is manipulated in a USoft application the USoft Rules engine must check a number of things. In case of a delete statement this mainly concerns referential integrity and whether business rules (constraints) apply. To do so, the Rules engine creates a kind of cursor using the "select ... with holdlock" statement that you mentioned.In your case, no extra work is involved for the Rules Engine, so a set manipulation could be used. Three settings in USoft 10.1 determine whether the Rules Engine can use set manipulations.The first is a Rules engine parameter that you can find in the USoft Definer:  ALLOW_SET_MANIPULATIONSDefiner Rules Engine parametersYou can find the description of this parameter at: Community: Allow Set ManipulationsIt shows ten cases when a set manipulation is not possible. In your case none of them apply.The second setting is a deployment configuration in the USoft Authorizer: Allow_disable_constraint. This is relevant if you use a Rules Service for your

2
marc
7 months ago
marc
marc
asked in Got a Question?

SQL Server "Connection is busy with results for another command"

Hi Marc,USoft does not support MARS. As you probably read, MARS is not enabled by default and you cannot specify: "MultipleActiveResultSets=true;" in the USoft database connection string.The USoft Rules service spawns threads that you know as Rules Engines.Every Rules Engine has (needs) a dedicated connection to the database server.So we do use multiple connections. A Rules engine processes one statement at a time. It will not accept new statements until the previous call completed.Therefor the error message you get is an enigma. How can a Rules Service put so much stress on a SQL Server instance that SQL Server will throw this error?May I suggest you create a Support ticket, so we can investigate this with you?Regards,Robert

2
marc
8 months ago
marc
marc
asked in Got a Question?

Implementing callbacks in the Service Definer

@Gert.K Hi Gert,Nice to hear from you! Hope all is well? Yes, we use the feature in a major project.Regards,Robert

5
R
1 year ago
marc
marc
asked in Got a Question?

Implementing callbacks in the Service Definer

Hi Marc,The option to use (OpenJDK) is available as of USoft version 10.0.1i.(See additional note USD-4183 SERVICE FRAMEWORK)You can find the option in the menu under Tools - Compiler settings: (Of course you need to change the path above to the path of the JDk of your liking.) Regards,Robert

5
R
1 year ago
J
jrumiak
asked in Got a Question?

How to create an "application modal" dialog?

Hi Jakub,I created a Window on the Events table and added a button with action:Application().Dialog_Box_for_Jakub( Self() ).Window().Create()On the Dialog I set the post-open property to:Label_1.label( thisLabel() )I added a user-defined property of Type String to the dialog. Then I ran the Window in the Designer and pushed the button. Here’s the result:Will that do? Regards,Robert

7
R
1 year ago
J
jrumiak
asked in Got a Question?

How to create an "application modal" dialog?

Dear Jakub,You open the dialog in the context of an Info Window (MDI child). If you open the dialog in the context of the application, it will be modal for the whole application. In the example below I open the dialog from a SQL Command Box:action Application().WindowCreate('Dialog Box - New' )(from a button you can skip the action keyword). Regards,Robert

7
R
1 year ago
A
Anonymous
asked in Got a Question?

Datetimestamp in milliseconds

Hi Dennis,As stated before by our Customer service desk, USoft does not yet support data types like datetime2 and datetimeoffset. Yet you can retrieve milliseconds using RDMI and store them in a column of data type varchar(24) or nvarchar(24).From the description of your issue I assume humans will not change the timestamp. They will only want to look at it (and maybe use it for sorting). That would be a prerequisite to make the workaround below reliable.In the USoft Definer:- Create a domain with data type nvarchar(24)    Do not(!) add an IO format to the domain.- Create a domain constraint that fills columns based upon the domain with:    convert( nvarchar(24), rdbms.getutcdate(), 127 ) || 'Z'e.g. when the column is empty (see image).If you define columns on this domain, inserting rows will give you a string like the output below:        2022-11-09T14:16:49.307ZThe thought behind adding the "Z" is that it makes presenting the timestamps in any timezone easier. Most programming languag

2
R
1 year ago
marc
marc
asked in Got a Question?

Determine rules service port inside the rules service?

Hi Marc,USoft has an off-the-shelf component OTS_WIN_PORT_INFO that returns information about port numbers.When you import this component, it will add a component table too.To find the Port number of your Rulesservice, you need its Process ID. I used a small .Net (C#) component to get that ID:using System;using System.Diagnostics;class PRC_UTIL{ public static int ProcessId { get { if (_processId == null) { using(var thisProcess = System.Diagnostics.Process.GetCurrentProcess()) { _processId = thisProcess.Id; } } return _processId.Value; } } private static int? _processId;}Please, use a better class name (or add the method to an existing class). 😆With these two components you can create a query like:select *from OTS_WIN_PORT_INFO "wpio"where wpio.PROCESSID = PRC_UTIL.GET_PROCESSID();This will retrieve all ports in use by the rules service. The port that is 'LISTENING' is your rules service port number. (wpio.STATE = 'LISTENING'). You can test this from the brows

2
marc
1 year ago
Gert.K
Gert.K
asked in Got a Question?

How to use values in a xml as a list in a sql statement

Gert,Here’s a  similar example used to transfer the output of xml.sqlexport into json: <?xml version="1.0" encoding="windows-1252"?><!-- Header --><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:output method="text" encoding="UTF-8" /><xsl:template match="Expression"></xsl:template><xsl:template match="Row"> <xsl:text>
	{</xsl:text> <xsl:for-each select="Field"> <xsl:text>
		"</xsl:text> <xsl:value-of select="@alias"/> <xsl:text>"</xsl:text> <xsl:text>:</xsl:text> <xsl:text>"</xsl:text> <xsl:value-of select="."/> <xsl:text>"</xsl:text> <xsl:if test="position()<last()"><xsl:text>,</xsl:text></xsl:if> <xsl:text>
</xsl:text> </xsl:for-each></xsl:template></xsl:stylesheet>And the same solution using templa

2
R
1 year ago
Gert.K
Gert.K
asked in Got a Question?

How to use values in a xml as a list in a sql statement

Hi Gert,Adding <xsl:for-each> might give you a starting point:<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <xsl:for-each select="annotations/annotation"> <xsl:value-of select="@value"/> <xsl:text>, </xsl:text> </xsl:for-each> </xsl:template></xsl:stylesheet>Cheers, RobertP.S. you might like to add quotes to the result

2
R
1 year ago
marc
marc
asked in Got a Question?

'Reuse Sockets' option in Service Definer Connection

Hi Marc,In an environment where USoft applications were communicating heavily with an enterprise service bus, we always added the DWord “TcpTimedWaitDelay” to the registry key you mentioned for each Windows server:TcpTimedWaitDelay: 0x1E (30 seconds)This reduces the time a socket is kept open. By default sockets are kept alive 4 minutes on Windows systems.I believe this was the source of our knowledge at the time:https://www.ibm.com/docs/en/sva/7.0.0?topic=SSPREK_7.0.0%2Fcom.ibm.isam.doc_80%2Fameb_perftuning_guide%2Fconcept%2Fcon_wintimewaitdelay.html Cheers,Robert 

5
G
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings