Uniface® Forum Home

Hi. I am new on this forum and I have a problem with a findkey statement Ik copied a programa,  made some adjustments and did a testrun with 2 records. Both programs (I will call them OLD and NEW)  refer tot a entity / table called MYTABLE (not real name). Only the entity is used, no local modification in the definition. The validate key trigger uses findkey to check if the record already exists before store. Record 1 OLD "C: PROGRAM_5 S: 0 P: 0" (); VALIDATEKEY; 1; [0]; findkey $entname, $curkey I/O function: S, mode: 1, on file/table: MYTABLE index: 1 =  Where ((NR_REKENING = 441202) And (DT_OVERZICHT = 09112023) And (NR_VOL = 5)) SELECT 0 FROM "MYTABLE" WHERE  "NR_REKENING" = :"WNR_REKENING" AND "DT_OVERZICHT" = :"WDT_OVERZICHT" AND "NR_VOL" = :" WNR_VOL" -> Hits selected: 0 . Record 2 OLD C: PROGRAM_5 S: 0 P: 0" (); VALIDATEKEY; 1; [0]; findkey $entname, $curkey I/O function: S, mode: 1, on file/table: MYTABLE index: 1 =  Where ((NR_REKENING = 441202)

Hello, We are creating REST interface for web access. Is it possible to use a name for the REST and an other name for the svc We have naming standards but the are not end-user friendly for exemple, the url would be              https://.../isAlivebut the internal svc woud be               SFY00000S I just wonder if there could be a http service renamer or something like that... I tried to create a signature or to use the [SERVICES_EXEC] of the .asn but I could not achieve what I tried. If anyone have an idea Thanks in advance Yves------------------------------Yves De MontmollinAon Suisse Sa------------------------------

Patch 10.4.02-039 Downloads Product availability Matrix (PAM) Downloads of this patch are available from the Rocket Customer Support Portal. Further explanation can be found here. CurrenciesAdd support for PostgreSQL 15 (PGS U1.7) on Docker image. FixesUNI-35691A runtime exception is generated when html:size property is set for ux-TextField widget using the Properties ExplorerUNI-35689A UX widget that is in error state sometimes fails to be updated correctly after execution of a trigger that has only output scope.UNI-35681The auto-indent feature of the code editors in the IDE sometimes fails to indent properly around function declarations and scope declarations.UNI-35651The ux-Switch widget shows incorrect animation when being toggled interactively.UNI-35416Starting the SCP service on Linux may give an error.UNI-35415"systemctl stop rms.target" or "rms.sh stop" does not stop the RMS server on the latest Oracle LinuxUNI-33520When the idle_in_transaction_session_timeout is

Hi,  I've just upgraded our development environment from 10.3 to 10.4.  During which the full compile output many errors of "sort/e" and "$runmode" being deprecated.  So the solution to both of these is simple (take the export used in the upgrade and do a global search and replace for sort/e-sort and $runmode-$edimode. Re-import the system xml export, re-compile.  However, did I miss a trick? Is there some setting which causes the import to automagically replace 'easy' deprecated statements like these, because the re-import and recompile is 4 hours out of my life.... If there isn't, wouldn't it be nice if there was?  Regards,  Iain ------------------------------Iain SharpHead of Technical ServicesPci Systems LtdSheffield GB------------------------------

Is there a way to know a FRM Widget type of a field on runtime? I would like to be able to set some properties on runtime if the widget type is uHTML ------------------------------Yuen ChongMrsRocket Forum Shared Account------------------------------

Hi, Does anyone  know the maximum size of the out parameter  of the os service ( oscommand.commandout) ? It's 8K for the in parameter, but it's not given for the out parameter. Thanks. ------------------------------Hortion GillesDedalus Healthcare FranceArtigues Pres Bordeaux FR------------------------------

Hi. I am new on this forum and I have a problem with a findkey statementIk copied a programa,  made some adjustments and did a testrun with 2 records. Both programs (I will call them OLD and NEW)  refer tot a entity / table called MYTABLE (not real name). Only the entity is used, no local modification in the enitity definition. The validate key trigger uses findkey to check if the record already exists before store.Record 1 OLD "C: PROGRAM_5 S: 0 P: 0" (); VALIDATEKEY; 1; [0]; findkey $entname, $curkeyI/O function: S, mode: 1, on file/table: MYTABLE index: 1 = Where ((NR_REKENING = 441202) And (DT_OVERZICHT = 09112023) And (NR_VOL = 5))SELECT 0 FROM "MYTABLE" WHERE  "NR_REKENING" = :"WNR_REKENING" AND "DT_OVERZICHT" = :"WDT_OVERZICHT" AND "NR_VOL" = :"WNR_VOL"-> Hits selected: 0 .Record 2 OLDC: PROGRAM_5 S: 0 P: 0" (); VALIDATEKEY; 1; [0]; findkey $entname, $curkeyI/O function: S, mode: 1, on file/table: MYTABLE index: 1 = Where ((NR_REKENING = 441202) And (

Patch 10.4.02-038 Downloads Product availability Matrix (PAM) Downloads of this patch are available from the Rocket Customer Support Portal. Further explanation can be found here. New Feature(s)Uniface Code Editors now support Auto-Indentation, this new feature only works when you are writing ProcScript. You can switch this feature off by setting autoindent=off in your usys.ini file, by default it is on: SourceEdit=usrcedit(font=procboxfont;language=uniface;indenttabs=on;indentsize=4;indentguides=off;autoindent=on)Uniface Code Editors have improved support for bi-directional text entry. By default this is disabled, when you are using RTL languages please specify 'bidirectional=on' in your SourceEdit widget definition in the usys.ini file, like: SourceEdit=usrcedit(font=procboxfont;language=uniface;indenttabs=off;indentsize=2;indentguides=off;bidirectional=on) FixesUNI-35660Wrong positioning with the options dropdown for the uxSelect widget when the select widget is locat

In the Uniface version 10.3 documentation, it says that the ProcScript command "scan" is unsupported and the new equivalent is $scan. However, this is no longer the case in the 10.4 documentation; it lists "scan" as unsupported but the new equivalent is also "scan" (same thing). Has "scan" been removed from the unsupported list, and thus, is still supported?------------------------------Jim MitchellState of OregonSalem OR US------------------------------

Hello, We have strong composant namig rules. We want to create web REST API functions with more friendly names.Is it possible to redirect the REST name to a specific component ?  for example : a call to an url https://...awebsite.../isAlive could call the service MYSERVICE I don't know if my explanation are clear enough If anyone has an idea, thanks in advance. Yves ------------------------------Yves de MontmollinAon Suisse Sa------------------------------

I've forgotten, and the staff member who normally handles this is away for Christmas. Where does one download the latest emergency licence for DLM?  Regards,  Iain------------------------------Iain SharpHead of Technical ServicesPci Systems LtdSheffield GB------------------------------

Does anyone know of a solution for purifying historical data? A solution where we can define scenarios for the destruction of data, for example, more than 10 years old? Taking into account the relationships defined in the Uniface model.------------------------------Martin CharbonneauMedisolutionRimouski CA------------------------------

We installed a Uniface application that has a uar file with all the compiled Uniface objects. When I tried to access the objects from IDE, I was not able to see the objects. Is there a way to import the objects from the uar file into the Oracle database? If the answer is yes, how should I do that? Uniface version is 10.3.02. Thanks, Anthony------------------------------Anthony ZhongRocket Forum Shared Account------------------------------

Afternoon all, Apologies, I have only recently become acquainted with Uniface, so am still finding out the art of the possible. Has anyone been able to user cisco's performance monitoring tool AppDynamics (Cisco AppDynamics - Cisco) to monitor an application deployed on Uniface? Any advice very much appreciated. Cheers Lee------------------------------Lee BoehmEnterprise ApplicationsRocket Forum Shared Account------------------------------

Hi, in the latest PAM there is no reference to Oracle 23C? Is this going to happen soon?------------------------------Martin CharbonneauMedisolutionRimouski CA------------------------------

Author: Weiye Li In the fast-paced world of software development, efficiency and convenience are paramount. As a low code application development platform, Uniface has been a trusted tool for many developers; however, sometimes there can be inconvenience: the absence of a built-in random function. But today, we are happy to introduce you to the solution to this inconvenience: the new $random function.  The Past: Uniface's Random Conundrum  For a while, Uniface developers faced a common challenge: the lack of a built-in random function to generate random values. This limitation meant that developers often had to resort to external software or employ unconventional methods to generate random data. It required extra effort and workaround solutions.  The Present: Embracing the $random function  By introducing the $random function, we have removed the need for external dependencies and intricate workarounds. Developers can now generate random data with ease and

Hi, I need to create syntax check that will allow to enter values consisting of digits and letters only (no sign etc) Example: A1A1A or 1A1A1 (so it can be mix of digits and letters only without any particular sequence). And no sign allowed like: /, *, _, % etc.  How should the ENT((X)) in field syntax property look like?  Best Regards, Jozef------------------------------Jozef ProkopovicUniface Community Edition Shared AccountUS------------------------------

Patch 10.4.02-037 Downloads Product availability Matrix (PAM) Downloads of this patch are available from the Rocket Customer Support Portal. Further explanation can be found here. New Feature(s)Uniface introduces 'Uniface UX' as an experimental feature. The current release consists of a set of pre-built UX widgets and UX widget Interface, these features will be enhanced over the coming releases. Using the UX Widget Interface, developers can create their own reusable UX Widgets that provide both the server and client-side logic to the objects in the component structure. This feature is still experimental. Interfaces might still change and incompatible features might still be added. Use this experimental feature to explore the possibilities of creating your own 'Uniface UX' for your applications, and to learn about the potential and added value that this feature might have for your projects. For more information check out our documentation and E-Learning deliverables. It is s

We installed a Uniface application that has a uar file with all the compiled Uniface objects. When I tried to access the objects from IDE, I was not able to see the objects. Is there a way to import the objects from the uar file into the Oracle database? If the answer is yes, how should I do that? Uniface version is 10.3.02. Thanks, Anthony------------------------------Anthony ZhongRocket Forum Shared Account------------------------------

Hi, Does anyone know the maximum size of the out parameter of the os service ( OSCOMMAND.COMMANDEOUT) ? Thanks. ------------------------------Hortion GillesDedalus Healthcare FranceArtigues Pres Bordeaux FR------------------------------

Hi Unifacers, for whatever reason our old U9.7 application has several form redirections in ASN files section [FILES] like prefix:form1.frm \\\\SERVER\\SHARE\\form2.frm or prefix:form3.frm \\\\SERVER\\SHARE\\form4.frm even using the U10.4 "exposed" folder deployment without UARs I can't use the trick anymore, tryed to specify it both in [FILES] and [RESOURCE] section like this prefix:form1.frm \\\\SERVER\\SHARE\\project\\frm\\form2.frm so searching in this sub I came across apparently the same request 5 years ago when there was only U10.3 at that time: https://community.rocketsoftware.com/forums/forum-home/digestviewer/viewthread?GroupId=217&MID=9001&CommunityKey=edb92b7f-cb45-44f3-9782-c48a111007d6&tab=digestviewer do you confirm that is no more possible to redirect any runtime component also in U10.4? any workaround? thank you------------------------------Simone PeccheninoLabinf Sistemi Srl IT------------------------------

I have a small repository migrated to Uniface 10.4 Community Edition. With the IDE I don't have a problem. When I try to test it or run it I get the error "Fatal error: 8011 - A license could not be acquired for UCLIENTW64.". I use the entitlement ID which is provided with the registration for the Uniface 10.4 CE download.I have also the Uniface 10.3 CE installed on my system.Log file output:2021-09-18 18:44:56.49 - Uniface session startedUsing license option LM_LOAD SUsing default for LM_LICENSE_FILE C:\\ProgramData\\Rocket Uniface 10 Community Edition\\License\\Requesting licenses from a license file.Using license manager SentinelLoaded 'lsapiw64.dll' from D:\\Project\\Programs\\Uniface104CE\\common\\bin\\lsapiw64.dll, version: 9, 8, 0, 0048Loaded 'lspmgmtinit64.dll' from D:\\Project\\Programs\\Uniface104CE\\common\\bin\\lspmgmtinit64.dll, version: 9, 8, 0, 0048Existence check: C:\\ProgramData\\Rocket Uniface 10 Community Edition\\License\\lservrc is a file.Existence check:

Patch 10.4.02-036 Downloads Product availability Matrix (PAM) Downloads of this patch are available from the Rocket Customer Support Portal. Further explanation can be found here. FixesUNI-35304HTML script and style tags containing an attribute get commented out wrongly.UNI-35169After clicking in the Uniface Code Editor, the cursor remains an I-Beam after moving out of the code editor.UNI-35125Function $decode takes CRLF characters as valid input for BASE64URL algorithm UNI-35304  -  HTML script and style tags containing an attribute get commented out wrongly. Solution available in patch(es):      10.4.02-036 Description:When selecting the JavaScript in the script part of the HTML it comments it out as Javascript with the // in front of each line.<script>JavaScript</script>As soon the script tag contains additional attributes or even a character the script tag is not recognized and the javascript is commented out

Howdy folks, I need to see if someone can help me find a download link for uniface 9.7.05 windows 32b. Specifically I'm need to get our install up to the version that has the updated CEF (version 81.3.3). Thanks in advance! -Brian------------------------------Brian MizellCommand Alkon IncorporatedBirmingham AL US------------------------------

by Dongbo Zhang We are excited to announce a significant update to the Uniface ProcScript language that brings powerful new features to enhance both the security and efficiency of your applications. Our commitment to providing you with top-notch solutions has driven us to integrate Base64URL encoding and Elliptic Curve Cryptography (ECIES, ECDSA, and Ed25519) into $encode and $decode functions. Base64URL Encoding: Simplifying Data Handling Base64URL encoding is a URL-safe variant of the traditional Base64 encoding. It allows you to represent binary data safely in text format, making it ideal for use in URLs, JSON, and other contexts where you need to avoid certain characters. With Base64URL encoding supported by $encode and $decode, you can seamlessly exchange data in a more efficient and secure manner. Elliptic Curve Cryptography: A Leap Forward in Security Elliptic Curve Cryptography (ECC) is an approach for asymmetric key cryptography, offering versatile applications in both encrypt