Uniface® Forum Home

Hi freaksI was forced to upgrade ourWindows-Server and SQL-Server to Version “2025”No problem but now, when I connect (from our application) the first time to the database it takes 8 secondssql/print "SELECT top 1 1 FROM aTable", "DEF"Profiling on MS-SQL give me no hint, as the duration of all action are a few microseconds.Using procmon results in this picture UnifAce connects and deconnect several time. Every reconnect last 0.5 seconds so in total we are near the eight seconds (measured by counting aloud)So what’s going on here?As I said, it's really just the simple SQL/print statement, nothing else.Oh yes, when I start the IDF, I got thisWhat happens here for about two seconds?Thanks for any hintIngo 

HiDoes anyone know where the “vlisting.xml” is found nowadays?Akerman:Here is an export of my custom listing viewer implementation: vlisting.xml.Regards RogerW 

Hi Unifacers,I would like to understand how to deal with VARIANT datatype in a COM interface with Uniface.VARIANT datatype as far as I’ve understood from Microsoft documentation is accepting either strings or numeric or any other datatypes and based on the datatype received it is reacting accordingly.Giving an easy understandable example (but the problem is generic):an Excel workbook could be composed from one or more worksheet; when more worksheets are available the program should select the one it wants to work into.After loading the Excel type library in Uniface and opening the workbook the operation to be called to move to a specific worksheet is:    sheets->get_item(handle out, variant in)- First param is an output parameter and it is the handle/pointer to the requested sheet- Second param is a VARIANT and it could be either a number or a string; when number it means the ordinal number identifying the requested worksheet or when string it means the name assigned to the workshee

We are loading a third party web page to an HTML widget in a DSP which is in turn loaded into an HTML widget from our C.S. Application. The 3rd party web page is displaying the dates etc in American format. and the navigator.language when queried in the inspector is “en-US”. The user/machine I am running the client application on is set to language “en-GB” when I run chrome and use the inspector. It is important that I can set the accepted languages and preferred language for my application as people will be confused by the date formats. How do you control these settings in the HTML widget/cefrender? NOTE, I am currently jumping through hoops to set the locale in the DSP code, but this is a 3rd party software… Regards, Iain

HiI have installed patch line Uniface 10.4.03.036 today. The Ide startpage tries to load “Loading community topics”, but it’s just spinning.If you restart the Ide, you may be lucky and it loads, but usually just spinning.It doesn’t lock the ide but..I think I have seen something about this in the forum, but I can’t find it.Regards RogerWStartpage 

We do all our exports to CSV by lfieldump and this works for yearsNow, however, a customer came up with the idea of using a DOS environment variable to determine the directory instead of fixed directories.So instead of "Q:\outpute\export1.csv,"it should now be "%app_export%\export1.csv"(where app_export is defined differently on each client).Unfortunately, Uniface cannot handle this; the file system converts it to "?app_export?\export1.csv," and the file system complains.Is there a simple solution for this, i.e., any letter combinations that can be used at the file system level to resolve "%%app_export%"?Of course, I can use a few tricks to ask Windows/DOS what the resolution is before each fieldump, and then replace that part. But I'm reluctant to check all our programs for this and make changes :-)A customer 

I have a CS form with an HTML widget on it. The CS form has a proc on it as per below. entry lp_refresh $fieldhandle("d_to_do_list")->$widgetoperation("JS:uniface.getInstance('SYD_TO_DO_LIST').activate('refresh')")endThe DSP SYD_TO_DO_LIST has an operation refresh as per below. Where “widget” is the name of a DSP container widget. operation refreshpublic webscope input output operation all_instances().refreshendscope if(widget != "" & widget != "SYD_BI") activate widget.refresh() endif return 0endThis successfully executes the refresh operation on the DSP contained by the widget container, and in turn on a widget contained by that container. So it all appears good. However, if I inspect the cef process (ENABLEDEVTOOLS=true), it builds up uncaught exceptions as per below, every time the refresh is fired. NOTE the refresh works, it just stacks an error in the dev tools.  VM124:1 Uncaught TypeError: uniface.getInstance(...).activate(...) is not a function at <anonymous>:1:58

Uniface and EDIFACTAuthor: i.sharp@pcisystems.co.uk (Iain Sharp) Has anyone used the EDIFACT standards to create/consume an EDI solution?  I'd like to determine if I need a third party app to convert to something useful, or if I can write something which will work directly in Uniface (or as a COM/DLL plugin).  If anyone has done similar, could you briefly say how difficult a task it was?  Regards,  Iain

Just for your information*)In UF 9, I had stored a list with GOLD- as a constant. That worked well.In UF 10, constants are created textually in DEFPARAM, and the semicolon acts as a comment character.The nice list is ruined :-(*) Even if Uniface were to correct this, it would take forever for it to be delivered in a version.“Unfortunately”, I need it right now. As a workaround, I used a pipe symbol instead of GOLD-;.And, of course, I have to convert | back to GOLD-; wherever it is used.

If anyone finds themselves in the same situation as I was after applying patch 26 to 10.4.03 and the Ctrl+F no longer brings up the find box in the proc editor, then just add this to your usys.ini and it will get you going again. My guess is that when they added the feature “Go to line number in code” they broke whatever the defaults that were baked into the proc editor because the search and the search and replace worked just fine without having to be defined in the usys.ini file(s). I opened a support ticket on this and eventually solved it myself. Hopefully, they address it or at a minimum, add it automatically to the usys.ini in future patches as they are applied.[userkeys]code.search=Ctrl+Fcode.searchandreplace=Ctrl+Hcode.gotoline=Ctrl+G

We have a web page built in against an HTML widget in our CS. Clicking a button on the web page uses a JS trigger to start loading a CS form and populating it with data. Whilst this is happening (can be up to 10 seconds before the entire form is loaded/shown) the web page is active and there is no indication at the client end that anything is happening. I’d like to turn on the ‘Processsing’ function, as per the refresh/loading of the page in the first place, from JS calls to the HTML widget before the activate of the triggered form, and off again after the form is loaded. (So the user doesn’t think nothing is happening and click the button several times (causing multiple instances of the form to fire up). Is this possible? Putting the DSP into ‘locked/processing’ state without the round trip to the server refresh… Iain

I have some data held in a field which I am painting on a DSP. Currently the field is set to statictext, but if I make the surrounding structure (div etc) have a fixed width, the field contents overflow it. I want to set them to wrap inside the width. However, the STATICTEXT field type translates to SPAN, and SPAN does not follow width or word-wrap, what DSP field type can I use doe display only text which follows the wordwrap stuff. I tried making the field ‘ATTRIBUTESONLY’ but then the text is not displayed (the ‘static text’ from the HTS is shown instead...) Regards, Iain 

I’ve recently been made aware of an issue with logical printers in Uniface 10.4 on Windows 11 workstations. If you have 2 or more logical printers defined, all logical printers in the list will appear to be mapped to the first physical printer in the list. If you click on Change, the printer definition appears wrong, but if you click on the chevron to see what physical printer is mapped, it will be correct -- HOWEVER, any specific settings that were stored originally when setting up the printer will NOT be correct.Support has suggested to manage this directly through proc code. Has anyone run into this issue and if so, what was the solution or workaround?TIA

We would like to understand whether Uniface 10.4 provides official support for Microsoft SQL Server 2025, or if support is currently limited to earlier SQL Server versions as defined in the Platform Availability Matrix. Our application is currently running on Uniface 10.4 with Microsoft SQL Server 2022, and we are planning an upgrade to SQL Server 2025. Can you please confirm whether Uniface 10.4 supports Microsoft SQL Server 2025, and if not, what the recommended upgrade path or compatibility guidance is?

Hi FreaksIt seems to me that whith every new UnifAce-Version the behavior of DISCARD changeIf the DISCARD in the READ-trigger itself the UnifAce enginea) recall the READ-trigger (very old Uniface versions, result sometime to an stack overflow)b) starts the READ-trigger again (current UnifAce versions)But we do have a globale procedure to execute the read.In this case UnifAce a) steps to the next statement (if then is no more to read)b) leaves all procedures and return to the READ-triggerc) restart the current procedure. Sic! (with 10.4.3.032?)    [i.e. cleans all variables and starts the procedure just at the begin.]I’m not sure with which version the behavior change from b) to c) or if there was other “reaction” in betweenTesting our product under UF10.4.03.32 leads to crashes when retrieving and/or sorting hitlist with rows to discard (due to right managament)The same routines in the old environment works perfect.Does some else do have DISCARDS in subroutines (called direct or indier

Hi there,when I was trying to update my Uniface 10.4 Community Edition installation I was told to reuse the original eMail received with my entitlementID; clicking on same button latest community version should be downloaded. Restarting the installation the upgrade should recognize the already available product and upgrade it. Last time I made that process was to install 10.4.3.021.Now I would like to update my installation to test new features that came out with latest product patches but clicking on original eMail received still 10.4.3.021 is downloaded.Am I doing something wrong or am I missing something in the procedures?Regards,Gianni

I would like to know if it is possible to get the current occurance using an ‘entity’ webtrigger. I can do this at field trigger level.  I can go up to a parent level to the occurance(as documented). When in a webtrigger at entity level, the ‘this’ is the entity and not the occurance.  There is no possibilty to go down to a child level(occurance).I can get all occurances for the entity or the nth occurance at entity trigger level.But there seems to be no property to get the current occurance at entity level.  I would have imagined it would be a basic need. What would be the solution to get the current occurance of an entity without using field level triggers. 

Hi Unifacers, I am currently visiting a Uniface VAR; we need to download an older Uniface version: U9.7.05.057 for 3 platforms: W32, W64, LID but unfortunately they seems NOT available anymore on official UnifaceRocket download site. I've tried to contact Amsterdam phone numbers reported on RocketSoftware web site (+31 (0) 786 322 800 or 0800 022 2961 (toll free)) with no success (Message answered: this number does not receive incoming calls). How to solve this issue? Thanks in advance. Regards,Gianni ------------------------------Gianni Sandigliano IT------------------------------