Uniface® Forum Home

Need PAM for uniface version 9.4, 9.5 and 9.6Author: rnavanee@hotmail.com (rnavanee) Please provide me Platform Availability matrix uniface version 9.4, 9.5 and 9.6. Please suggest me from which uniface version will support windows8 and SQL Server 2012?

Check for special non printable character in a fieldAuthor: lalitpct@gmail.com (lalitpct) I would like to put a check to allow only characters in a field , blocking special character (non printable which at times corrupts database). 1)Is there way to do using syntax. 2)Below thing doesnt seems to work, as it is unable to identify non printable charactres. if (@$fieldname != '@*') message/error "Only alphanumeric characters are allowed in password" dum_new ="" return(-1) endif 3)Is there way to show them on screen. In syntax I see characters allowed -'ASCII' will this ensure to have only alphanumerics in the field. Also how to test these??

Problem to store german characters with 'umlaut' (ä, ö, etc) in an Oracle 11g databaseAuthor: ncolmart@medinfo.fr (ncolmart) Our configuration is the following : - Uniface 9.4.01 (r110) - Oracle 11g R2 - We use the database as a non unicode database. Therefore, we set $WIDE_CHAR_BEHAVIOR option to 'Charset'. Thus VW* fields are mapped to VARCHAR2 in Oracle - Database parameters are the following NLS_LANGUAGE : Database=AMERICAN, Instance=AMERICAN, Session=GERMAN NLS_TERRITORY: Database=AMERICA, Instance=AMERICA, Session=SWITZERLAND NLS_SORT: Database=BINARY, Session=GERMAN NLS_DATE_LANGUAGE: Database=AMERICAN, Session=GERMAN NLS_CALENDAR: Database=GREGORIAN, Session=GREGORIAN NLS_COMP: Database=BINARY, Instance=BINARY, Session=BINARY NLS_LENGTH_SEMANTICS: Database=BYTE, Instance=BYTE, Session=BYTE NLS_NCHAR_CONV_EXCP: Database=FALSE, Instance=FALSE, Session=FALSE NLS_NCHAR_CHARACTERSET: Database=AL16UTF16 NLS_RDBMS_VERSION: Database=11.2.0.1.0 NLS_CHARACTERSET: Database=WE8

Using Encrypted DataAuthor: i.sharp@pcisystems.co.uk (Iain Sharp) So, I'm trying to store data in a particular field in the database in an encrypted manner, to prevent our report writer (crystal reports) from being able to report on it. I have written an encrypt and decrypt proc (cp_passwd) as per below, but I have two problems 1. From the documentation, it seems that to store data in a varchar I should be using the USTRING stuff to ensure there are no embedded nulls, but adding it in causes the whole thing to fail. 2. Putting this code <$fieldname>/init = cp_passwd("DECODE",<$fieldname>) in the decrypt trigger of the field, causes the data file to lock almost as soon as read (paranoid locking), I need it to stay as cautious locking (as is set) so is there any way to make the decryption not count as modifying the field? returns string params string p_type : IN string p_inparams : IN endparams variables raw v_rawpasswd string v_inparams endvariables selectc

Upgrade Uniface 9.4 to Uniface 9.6.Author: sergio_enbe@hotmail.com (Sergio Encinas Benítez) We're planning to upgrade this month (July 2013) our version of Uniface from 9.4.01.01 (0302_2) to 9.6. We want to know some advices for us to be prepared for the migration of the forms, reports, etc. We currently have the UDE for Windows XP (1GB RAM 32 BITS) and now we're going to install 9.6 in Windows 7 (16GB RAM 64 BITS). We also use Citrix Server and our DBMS is Sybase 15.0.3. Thank you

Problem with WSDL (complex?) input parameterAuthor: p.knapek@fullsys.cz (p.knapek) Hello, I have a problem with passing an input parameter to WSDL service http://adisrws.mfcr.cz/adistc/axis2/services/rozhraniCRPDPH.rozhraniCRPDPHSOAP?wsdl I have imported the WSDL to Uniface (9.6.01) and Uniface created the signature and the model with entities. There are 2 operations in signature: The first named GETSEZNAMNESPOLEHLIVYPLATCE with no input and 2 output parameters (occ and string), which works fine. The second operation is GETSTATUSNESPOLEHLIVYPLATCE, where the problem with passing parameters occurs. There are 3 parameters (occ STATUS:out, string DIC:in, string STATUSPLATCEDPH:out). If I try to pass a simple string to DIC parameter ("123456"), or a list ("123456*;654321") or a XML snippet (like "123456654321"), the expected result is not returned (XML) in STATUSPLATCEDPH. There is the only difference between GETSEZNAM... and GETSTATUS... operations in the &

PDF Printing from UnifaceAuthor: ewan.bauld@yodel.co.uk (EwanBd) Does anyone know how to print PDF files from uniface? The PDF files we are attempting to print have been previously created using a call to a webservice. We have found one solution which uses ghost script but this opens an unsightly dos box and prevents the user from doing anything else in the app. What we really need as a call out to some sort of background service. Any help would be most welcome.

Call out to a web service from Uniface 9 SSL certificate issue.Author: stuza1@gmail.com (stuza1) Problem: Unknown CA on ssl setup calling a web service form Uniface 9. I am aware this is not a pure Uniface issue and relates to Tomcat but also to Uniface configuration. 1. We have a call out to a web service working from Uniface 9/Tomcat on a windows system using http. 2. We are however encountering problems in setting up bi-directional ssl with client auth. 3. I suspect that I do not have something set up correctly in Uniface and / or Tomcat, I suspect that its the keyfile containing the trusted certificate authority of the server I am calling out to. (see the last line in point 6 below) I don't know which keystore is the problem. 4. The Uniface help file explains how to set up ca-bundle.crt and personal.crt for client auth - Verification for Web Services over HTTPS I have ca-bundle.crt in the \\usys directory c:\\Program Files (x86)\\Compuware\\Uniface 9.6.02\\common\\usys I have the

TabEx: Setting fonts and colors?Author: zdenek.socha@fullsys.cz (sochaz) Hello, we've got a simple form with 1 editbox and a tab widget (above the editbox). BTW there are other similar forms with 2 and 3 editboxes, but this is not important. The form is quite similar to simple text editor (like notepad) with tabs - so you can edit more "texts", but you can see only one text at the time (like notepad++). Number of tabs equals to number of texts, changing tab changes the text in editbox and so on. Hopefully this is clear. Number of tabs and texts on the tabs is dynamic. Sometimes 3 tabs are shown, sometimes 10. Now I want to inform user, if there is any text "under" the tab and if that text is modified. The simpliest way seems to be to change color and font of text on tabs (in tab widget). I mean, for example, the tab containing text would be shown with bold font. Modified texts would be "symbolized" with tab, which would have bold italic font and red colo

Passing DSQUERY as parameter when opening exclusive urouter connection in SYBASEAuthor: lalitpct@gmail.com (lalitpct) We are opening an exclusive connection by below command and then on server asn we have hardcoded the servername (server1 in below example) for database connection (SYBASE) , at present we have 14 different servers (server1 to server14 ) . Exclusive connection ------------------------- open "|%%ID|%%$PINFO$|%%$$SERVER /ex", "$LOG/NET" server.asn ---------------- [PATHS] $DEF SYB:server1.database1|?|? because we have hardcoded server1 i need to create 14 different asn files for each server , is it possible I can pass this as parameter from open statement . In the uniface documnetation i checked that if i dont provide server name then it will connect to server specified to variable DSQUERY , but not sure how do i set that as for that . In short below things will be helpful 1)if servername can be passed from open connection 2)if we can set DSQUERY the

U94 pratt error using ORA11 clientAuthor: mail@gandg.it (TheAleph) Hi, I usually work with dbase ORA10g and client ORA10g, now testing a pc with client ORA11r2 there is an error on PRATT table; the table is created as in sql files (OPTIONS field type BLOB) the error is about this field .......expected as LONG RAW (?) so can't print. Try to create and link via asn a copy table with the field long raw but the message is 'incorrect print job model can't print' Is it an Oracle or Uniface problem ? Thanks everyone. Roberto

SHIFT+MOUSE Click Multiple selectionAuthor: palakarthik1@gmail.com (palakarthik1) Hello All,        Could some one please let me know how to implement SHIFT+MOUSE Click multiple selections in Uniface Grid. Thanks alot. Karthik

How to read XML files.Author: felipedonatti@hotmail.com (fdonatti) Good afternoon everyone, I'm looking for some example of reading XML files by Uniface. I found the UXMLWrite and UXMLReader but nothing very explanatory. I wonder if anybody here the forum has a working example to send me.

New features in version 9.6?Author: ivanandradesantana@gmail.com (IvanSantana) Hi I wonder if someone has briefly the new features of version 9.6 compared with version 9.3.

recovering solid databaseAuthor: lalitpct@gmail.com (lalitpct) using idf 9.6 i was acessing solidb 6.5 , but now the evaluation period got over and I am not able to acess my idf. Is there way to recover it?

U_WEHERE Help NeededAuthor: se8mis@ceb.lk (se8mis) If I need to retrieve a set of Objects which having a maximum rev_no in a given table what will be the u_where condition Assume my table data as follows , I need to get only the * records TR_TBL DOC_NO REV_NO STATUS DEPT_ID AMT *Docno1 3 1 200 1 ---> Need to get Docno1 2 2 200 3 Docno1 1 1 200 1 *Docno2 2 1 200 10 ---> Need to get Docno2 1 2 200 1 *Docno3 2 1 200 2 ---> Need to get Docno3 1 1 200 1 I am using uniface 9.5.0.1 Version Regards Asiri

$occmod resetAuthor: juerg.fross@teamspirit.ch (jfro) Hello all I would like to reset $occmod in an Uniface form. 1) The user updates some values in a multiple occurence 2) I check if he is allowed concerning the data already in the database. Depending the result of my checks I restore the old value. 3) As $occmod is still set I'd like to reset it - but it doesn't work (no error - but no changing of $occmod) Any recommondations? Thanks all! Jürg

Services and Milestone CountsAuthor: cdouglass@siriussoftware.com.au (Colin) Is there a way to display milestone counts on a client PC whilst a service is running? We have several services that take around 15 minutes to complete. Some of our users start to get a little worried something is wrong if nothing displays for that long. Before services it was easy just display a message every 100 or so records. Now, of course that can't happen. Thanks, Col Douglass

Cannot restore focus on current field, due to active path changes in focus triggerAuthor: jean-philippe.dumont@telus.com (jpdumon) Hi... I just want to know if someone already receive this warning... It's the first time we got this and looks like in a random basis so I can't reproduce the error and have no more detail in my logs for now... Warning : Cannot restore focus on current field, due to active path changes in focus trigger. Thank you if you can help ! JP

Columnwidth in tree widget. Author: i.sharp@pcisystems.co.uk (Iain Sharp) When the tree widget list view column sizes are altered, it now fires an extended trigger called columnwidth. When I define the column sizes, using $fieldproperties("FIELD")="FORMATS=CL10·!CL25·!TC6·!TL17·!CL·!CL6·!TL17·!CL13·!CL25·!CL·!CL25·!CL·; LABELS=Reference·!Location·!CHS·!Due Date·!Owner·!Priority·!Date Last Amended·!Contact·!Stock Item·!Cus. Order Ref.·!Developer·!Tester" I have been using character counts. If I resize the 4th column in the tree the columnwidth trigger gets ID=3 (because 1st column is Id 0), and width=117. Does anyone have a good tip as to what one could do WITH this information to make it useful for the next time around, I'd like to store the user's preferences for column sizes and reset the column widths t

9.6 component level Defines triggerAuthor: zoltan.seres@gmail.com (ZoliZoli) Hi, I have recently installed 9.6.01 and tried to compile sources with "#define" in the component level Defines trigger but the following error happens: (FIND) 1 message/info (FIND) error: 1000 - Syntax error (Statement not valid) error: 1112 - Total Proc compile errors: 1. phase completed with error-code -1 If I move the #define statement into the Operations trigger then the compile is successful. The same component compiles without any error on 9.5.01. Anybody experienced such an issue? Thanks in advance, Zoltan

Obtaining the Windows handle of a componentAuthor: mrpetzl@hotmail.com (M Wilson) Does anyone have a reliable way of obtaining the Windows handle of a Uniface component via code from within a Uniface application? It would be nice if this was available as a parameter via the component properties, or similar, but it isn't - I understand it would only be available via a 3GL call. Any ideas appreciated.

Password field in Uniface?Author: zdenek.socha@fullsys.cz (sochaz) Hello, I'm trying to make our application in Uniface looks a bit better. For password fields we used editbox with NDI syntax and NoDisplayCharacter set to 42 (an asterix). But it does not look great nowadays, so I wanted to change it to a bullet or something more common. According to Uniface Library "The default value is a bullet (decimal 165)." But that's not true... the decimal 165 is the yen symbol, not a bullet. I have tried to enter a 149, which should be a bullet character, but this results in very strange behaviour (nothing is shown at all). Real bullet character seems to be U+2022, which is a hex value, so this should be 8226 in decimal. So I have tried to enter 8226 as No Display Character, but Uniface changed it to 255. So it seems it is not possible to use any character with ASCII code greater than 255. I just wonder, what do you use as No Display Character for password field (editbox) in Uniface

passing database as parameter while opening exclusive connection Author: lalitpct@gmail.com (lalitpct) Below urouter.asn is running on server and using it we are trying to open different database , I created 2 asn files for that. both asn file has everything same but database as shown below. From application we open exclusing connection using asn gui_1.asn or gui_2.asn urouter.asn ----------- [SERVERS] startup = /opt/uniface/9601/common/bin/userver -maxreq=1000 -dir=/var/dev/ap /asn=/opt/start/startup.asn db1 = /opt/uniface/9601/common/bin/userver -maxreq=1000 -dir=/var/dev/ap /asn=/opt/dev/sources/asn96/gui_1.asn db2 = /opt/uniface/9601/common/bin/userver -maxreq=1000 -dir=/var/dev/tap /asn=/opt/dev/sources/asn96/gui_2.asn gui_1.asn ------- [PATHS] $DEF SYB:db1.schema|?|? gui_2.asn --------- [PATHS] $DEF SYB:db2.schema|?|? I want to avoid using 2 asn files and need to remove db1 and db2 and put the database when exclusive connection is used as shown below New one ----------- urouter

How to execute unix commands on server without using commadout in client/server architecture ??Author: lalitpct@gmail.com (lalitpct) We dont have license feature UCLTSRV which is needed for commandout , Is there any other way to execute unix related commmands activate "osunix".commandout("pwd",output)