Uniface® Forum Home

WRITE statement - How the aphanumeric value is mapped to numeric fieldAuthor: jayesh.g.patel@accenture.com (Jayesh82mscit) Hi All, In the recent time, we faced the problem in which while writing the data into database through WRITE statement, value part was behaving differently. Let me try to explain with little mockup TABLE- PolicyMaster (having 258 fields/columns) SCORE_STEP_UP (Field sequence# 254)  - Numeric field with 3 digit length CREATED_BY (Field sequence# 255) - Varchar field with 15 chars length While making a change to Uniface MODEL for one of the another entity (lets say Table#2), unknowingly the sequences of above fields (from table -PolicyMaster) got swapped. We do use the Subversion for source control though not sure if any ways to control to prevent this in future. However while navigating the application, some of the users, system was performing well but for some it wasn't. When observed the patterns and logs, it was concluded that the userid value is

OCX Refresh2 WebbrowserAuthor: satheesh.balu.m@gmail.com (Satheesh) Hi, I'm trying to refresh the url using the $ocxhandle $OCX_FOR_IE$ -> REFRESH2(v_level)  I tried to pass the v_level as string. I also tried as numeric. But I get the below error in both the case: ICCDRV-COM-ERR Error with ICC system occurred, The COM method "Refresh2" threw an OLE exception: HRESULT=0x80004005, description="", source="": COM error 0x80004005, described as "Unspecified error"  The parameter for Refresh2 is defined as VT_VARIANT in the webbrowser signature. How can I refresh the url from Uniface ? is it possible ? Thanks, Satheesh

Problem reading from SQL/Server SmallDatetimeAuthor: parcaya@compuamerica.com.ve (parcaya) When we try to read an entity SQL/Server by a field type “fecha” SMALLDATETIME returns an error - 3. We have tried different options and it does not work. Define in SQL/SErver: fecha  smalldatetime If the field is a primary key or part of it does not allow reading the entity In Uniface Model are define as (from load definition): Data Type: Combined date and time Interface: E9 Can someone help? Thanks

[RESOLVED] scanning between two local variablesAuthor: lalitpct@gmail.com (lalitpct) I used below syntax and in both the case I don’t get result When I hardcode lv_tmp then I get correct result. message/info “filename : %%filename” message/info “lv_tmp : %%lv_tmp” scan filename,“%%lv_tmp”                       ;$result > 0 even though variable matches scan filename,lv_tmp                                ;$result > 0 even though variable matches scan filename,”/server/test/uat/report”  <– works fine   Can some one suggest which is the correct syntax

[SOLVED] $ude getReferenceListAuthor: norbert.lauterbach@infraserv.com (Lauterbach) Hello,   how can I get the Information from $ude getReferenceList? In the idf.asn I have : $SYMBOL_TABLE       2 So "SELECT * FROM uxcross" results to 266761 entrys.   I tryed : V_STRING = $ude("getReferenceList", "symboltable·;component", $ITEM$, "", "") V_STRING = $ude("getReferenceList", "symboltable·;form", $ITEM$, "", "") V_STRING = $ude("getReferenceList", "symboltable·;model", $ITEM$, "", "")   But putmess $procReturnContext just Returns : Context=UDE getreferencelist Which is the correct Syntax for this command??? The documentation seems not to be valid!?   Regards Norbert

NoEditBox is editableAuthor: norbert.lauterbach@infraserv.com (Lauterbach) In file usys.ini there is a Definition [widgets] ; Logical widgets for development environment NoEditBox=ueditbox(font=editfont;3d=off;dimmedbackcolor=off)   Using this Definition as Widget Type for a field, the field can be edited. Is it possible to define the widget to be a real "NoEditBox" without the Need to define Syntax as "NED,NPR"?

xmltostruct Author: satheesh.balu.m@gmail.com (Satheesh) Hi, When I use xmltostruct, and if my xml has encoding = "UTF-8" it is working fine. But when I have UTF8 (may be invalid one) I get the error -1503 sometimes. I would like to understand why I don't receive the -1503 error always when I use UTF8. Anyone knows about this? Thanks, Satheesh

Loss of vertical barAuthor: parcaya@compuamerica.com.ve (parcaya) Hi, while inside the editor handling vertical bar is lost. You must use the keys. Do you know something about this?

[SOLVED] MSS U5.0 driver producing a CAST errorAuthor: p.lovati@pokerspa.it (PaoloLovati) Hi all, a table has its primary key defined as numeric so it has NOT NULL in the database. The key has to be filled by a db SEQUENCE, so it is left empty in the component. When the WRITE applies the MSS drivers tries to store spaces instead of NULL in the field, producing a CAST error. The ORA driver handles this correctly. It looks like a bug (BUG 29424) solved for DB2 driver...   Uniface : [MSW] 9.6.08.02, X801 SQLServer System Information : ------------------------------------------------ Driver : sqlncli11.dll 11.00.3000 ODBC Version : 03.80.0000 Driver ODBC Version : 03.80 SQLServer2 Database Information : ------------------------------------------------ DBMS name : Microsoft SQL Server DBMS Version : 11.00.3156   Thanks for any reply. Paolo

[SOLVED] DspContainer don´t load DSPAuthor: ablancouribe@compuamerica.com.ve (bioalexy) Hi After installing the last ServicePack for 9.7.02 the Uniface Widgets stopped working on all my DSPs. Please help.

[SOLVED] USYS Path Logicals not workingAuthor: lalitpct@gmail.com (lalitpct) Below works fine usys:*.dol = /opt/dev/ap/sources/dol/chui/*.dol But to clean up the hardcoded path I need to use Logical path , which is not working with below changes.. =================== asn ==================== [FILES] usys:usysidx.frm = usysii_smart:sources/forms/chui/usysidx.frm usys:usys*.frm = usys:usys*.frm usys:*.dol = usysii_smart:sources/dol/chui/*.dol ================================================ ini file ================================================= cat /opt/uniface/setup/uniface/adm/usys.ini [paths] usys=/opt/uniface/setup/common/usys usysins=/opt/uniface/setup usyscom=/opt/uniface/setup/common usysuniface=/opt/uniface/setup/uniface javascript=/opt/uniface/setup/uniface/webapps/uniface/dspjs usysii_smart=/opt/dev/ap

9.7.03.02 (G306) DSP : change on how triggers are firedAuthor: philippe.grangeray@agfa.com (Philippe) Hello, the behavior on how triggers work in DSP has changed between 9.7.03 and 9.7.01. For instance, if we have an Attribute Only field around a Flat Button field in a DSP: Click on Flat Button: 9.7.01 : only trigger of Flat Button is fired: that's what we expect. 9.7.03 : both triggers are fired: but, we don't want the onclick event to bubble. There is an unassigned variable, which is tested in uniface-uncompressed.js:16809, _uf.view.callTriggersImmediately. If it is assigned to true, the ancient behavior comes back. Is this feature, well thought, will be documented, and should be used ?

sql/data error on oracleAuthor: eitan@amital.co.il (hareitan) I've just tried the new sql/data on oracle 10.2.0.3.0 and Uniface 9.6.05.02, and got DB error: ORACLE Driver Error [-6]: Unknown driver request.... sql/print works fine. Any ideas?   Thanks Eitan

Html-widget with XMLAuthor: roger.wallin@abilita.fi (rogerw) Hi, Some quick tests gave me the following issue; Having a XML-file and a XSL-file, I cant get the (styled) XML showing up in the HTML-widget. Removing the styling, I can see the xml-structure. It's also possible to see a jpg or some ordinal web-page in the widget. The styled XML shows correct in a browser, so I suppose there is some problem with the path.... I have tried with a path to the xsl and also putting the xsl into the working directory, then removing the path of the xsl in the xml-file. (I haven't tested putting the xsl on a http-path). Regards RogerW XML: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="c:\\temp\\catalog.xsl"?> <!-- <?xml-stylesheet type="text/xsl" href="c:/temp/catalog.xsl"?> --> <!-- <?xml-stylesheet type="text/xsl" href="file:///c/temp/catalog.xsl"?> --&

/exe UEXTNAuthor: andrew.wilkins@hl.co.uk (Andrew Wilkins) Hi, I recently discovered the ability to open the IDF in component editor for a given form component: ...IDF /exe UEXTN NODDY_FRM So far I can't get it to load a service directly - it seems only to retrieve UFORM for forms:  Where (((UINHERIT = F) And (UTRANSACT = '0'))) And ((ULABEL = 'NODDY_SVC')) -> hits 0 . Has anyone been able to use .exe UEXTN to edit non-form components? I note that this issue was raised in this forum 5 years ago but there was no resolution back then. Is there still a wish-list?

UHTTP->DUMP_FILE_CONTENTS:File not createdAuthor: i2stiller@gmx.de (istiller) Hi freaks Just doing a few file transfer by UHTTP, which looks pretty good. BUT ... But then sometimes, UHTTP->DUMP_FILE_CONTENTS does not create a file on disk, even if GET_INFO("length) returns the correct length. A retry with exactly same paramters dumps the file Any idea? Ingo   Here a few lines of debug messages: -------------------Try 1 -------------------------- DUMP_FILE_CONTENTS('C:\\Users\\user\\AppData\\Local\\Temp\\~FILE1.pdf', 'TCPRCVBUF=1m') >SEND('http://address','GET','access_token=xyz') < <SEND('http://address','GET','Cache-Control=no-cache, no-storeTransfer-Encoding=chunkedContent-Type=application/pdfServer=Microsoft-HTTPAPI/2.0Access-Control-Allow-Origin=*Access-Control-Request-Methods=GET, POST, PUT, DELETE, OPTIONSAccess-Control-Allow-Headers=Content-Type, Accept, Authorization, Access_Token, responseTypeAccess-Control-Expose-Headers=Content-Type, Co

Generat Call-In Stub for CAuthor: thomas.young@young-consulting.de (Thomas.Young) If you create stub-in files for c, in UNIFACE you use the /sti switch. In UNIFACE 9.3 there is a bug, so you have to use /sto with a app named. Mails form the LAB: Indeed in Uniface 9.3 it looks like /sti and /sto have been changed around. I had a word with the developers and they said this has to do with the introduction of the $ude function and the re-thinking of some (apparently inconsistent) terminology, but I am not sure that this particular change is intentional or not. I will investigate this further and get back to you. Hallo Thomas, I have verified that this was not intentionally changed, and is in fact a bug. I have created bug 28122 for this, and will request that it be fixed in the next service pack for 9.3, which will be MP01. It is too late to include this fix in patch P104.

9.7.01: the output format for $PROC_TRACING has (dramatically) changed (currently not documented)Author: ulrichmerkel@web.de (ulrich-merkel) according to http://unifaceinfo.com/fixes/issuelist/31092.php the output format for $PROC_TRACING has (dramatically) changed (currently not documented)   For the group of us who, for productivity reasons, apply some post processing to proc tracing this means some major change in "parsing" the (data-)line to reconstruct the current output format. AFAIK, if one needs to have the procerror in the tracing, it is even in 9.6 possible to have a customized $PROC_TRACING_ADDITION.

Management of the DLM with Terminal Server 2008Author: antoine.picaud@free.fr (apicaud) Hi, We have an application who is started by rdp file in a remote solution. Unfortunatly, each launch of the application open a ticket on the DLM for the same user because we have a different session id by TSE. But licence of TSE count only the number of person and DLM count the number of session and not by user. Do you know an issue to resolve that ? Regards, Antoine

Disappearing $procerrorsAuthor: awilkins1@btinternet.com (AyeJayUU) There used to be 2 useful $procerror -1113 & -1122 These let you know you'd made a mess of a call or activate and got the params wrong. Now these no longer kick in. Trying to call a proc with the wrong arguments should be an error. What did I miss ?

9.7.01: workaround if a struct parameter of an operation causes crash during compileAuthor: ulrichmerkel@web.de (ulrich-merkel) in issues: http://unifaceinfo.com/fixes/issuelist/31098.php BUG: 31098 - UF97: Compiling operation with Struct parameter can cause crash there is a workaround to run a successful compile

Multirecord issue with or without a gridAuthor: gianni.sandigliano@unifacesolutions.com (gianni) Uniface 9.6.07 - we are facing with a recurring issue with entities showing multiple records in a non modal form either with a grid or without a grid: Example 1: 1) The user is positioned on record 1 of multiocc entity (in this case in a grid) part of a NonModal Form ($curocc("EntityName") = 1) 2) The user click on the row 8 header requesting in this way to go into details for that row 3) The ExtendedTrigger is starting this code RowHeader_LClicked: setocc "EntityName", ROWNUMBER ; ROWNUMBER is equal 8 call myLocalProc ; This local proc is starting another NonModal Form to manage row details 4) The user exit the called form; it does not matter if accepting or quitting it. Note: at this point $curocc("EntityName") = 8 5) The FormGetFocus trigger code in the calling form is started Note: during execution of all the codelines into this trigger, up to "done&

[SOLVED] Problem downloading hotfix for security vulnerability 30815Author: zdenek.socha@fullsys.cz (sochaz) Hello, I have tried to download the hotfixes but I always get the following: Uniface Downloads: 404 Not Found The page you requested does not exist. Is it just a typo in URL's? Or my access rights? Or have the files been removed? Zdeněk Socha

Tomcat Security IssuesAuthor: knut.dybendahl@gmail.com (Knut) Hi all, I'm not sure which forum this belongs to - but since it's starting with the development of secure web applications I thought I'd drop it in here. There are a number of security alerts and warnings associated with the version of Tomcat shipped with the latest version of Uniface - up to and including version 9.6.06 - with 1 security hole and 11 security warnings on a PCI check from Comodo - causing sites to be PCI non-compliant (which is NOT good). From what I can tell, all of the issues have been resolved with the latest version of Tomcat, version 7.0.55. 1) Are there any issues with upgrading the Tomcat server to 7.0.55 since we'd break the long-standing "the Lab hasn't tested that specific configuration - hence it's unsupported" mantra? 2) Does the Lab / others in the Uniface community have a best practices method to stay on top of Tomcat issues? 3) Would I be able to shield these issues by using IIS as

[SOLVED] Struct DataType not available anymore in 9.6.07Author: richard.gill@agfa.com (richard.gill) In 9.6.06, the Struct DataType was available for the model field definition. This type is also available in 9.7. The 9.6.07 version does not permit such a DataType. We have created a tool (to encapsulate the handling of REST requests) based on an entity defining entries in its Local Prod Modules. Those entries use non-database fields of type Struct to contain revelant information about a REST request and the to be generated response. This method permits us to avoid using component variables for a generic and shared tool. It seems to touch only the IDF, as the DataType now appear empty in the model, while a component compiles with this entity, and struct fields are addressables.