Uniface®

Background color in rich edit box?Author: david.andersson@umu.se (DavidAndersson) Hi there. I was wondering if there is any way to change the background color on a rich edit box. Either via some sort of property or by RTF syntax. I use the field for highlighting some words in a text with bold font and red color (the user is not allowed to edit the text). The problem is that i can't get the rich edit box to look like the other edit boxes (that are non editable) in the application. I found out that i can make the field dimmed to get the grey color that i want, but then i cant use the scroll bar :-/. Any help would be much apreciated. /David Andersson ITS Sweden

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

Default preferences for new user.Author: anne_vw@telenet.be (anne_vw) Hi, when i start op UDE with a new user he automatic gets preferences. When i looked at the table UUSRPRF i saw a user %U. I thought these where the default setting when creating a new user. But it is not. Is it possible to define default settings, so every new user receive this settings? I know i can export and import the settings but i would like to have it automaticly. I read that the preferences are defined when installing Uniface but i would like to know if i can changes them later one. Thanks Anne

ASN file nameAuthor: p.lovati@pokerspa.it (PaoloLovati) Hi all, does anyone knows if Is it possible to obtain the ASN file name and path passed to the application from the comman line switches? Thanks.

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.

Barcode 129CAuthor: cdouglass@siriussoftware.com.au (Colin) Has anyone has any experience printing a barcode using CODE 129C?

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

Uniface 9.6 ulibrary.iniAuthor: eitan@amital.co.il (hareitan) Hi Due to Windows security problems, we used to put the contents of the common/doc folder (ulibrary.chm etc) on a network shared folder, add the path to the HKLM\\SOFTWARE\\Wow6432Node\\Microsoft\\HTMLHelp\\1.x\\ItssRestrictions registry key, and pointing usys.asn to that location. It all works fine on v95. On v96, while starting the Help from IDF, it looks for a file called ulibrary.ini - we had it on v95, but can't find it for v96. Where can I find that ulibrary.ini file? Thanks Eitan

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

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

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

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?

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

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

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.

Max Occurrences/Records in componentAuthor: i.sharp@pcisystems.co.uk (Iain Sharp) When defining an entity the developer can set the minimum and maximum Number of Occurences (defined as Maximum/Minimum Records in the documentation). This can then be overridden at component level. Is there any way of finding out the current value of this for a component, so behaviour can be coded into the model in, for example, the $collectionhandle("ENTITY")->add() I'd like to do this without having to add a component level define, using something like $entinfo or $entityproperties. Iain

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?

hide columns in a grid widget uniface 9.6Author: ivanandradesantana@gmail.com (IvanSantana) Hi I'm developing an application where I am using a grid widget, and need to create a column hid, and not want to show on screen. How can I do this.

TXT entity limit?Author: mark.wheeler@tribalgroup.com (Mark Wheeler) Is there a text (TXT) file entity size limit in Uniface (we're currently on 9.5)? We have just created a new entity with 767 fields,resulting in 3560 characters. When we try to read a file it crashes Uniface. We created a cut down, smaller 10 field entity with the same properties and it works fine. Any ideas? Many thanks Mark

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

Automated Testing Tools with Uniface??Author: adrian.gosbell@synapse-i.jp (Adrian Gosbell) Here's a question.. we're planning on replacing our automated testing tools that we use to test Uniface. At the moment we use Testpartner which since it was sold to Microfocus, has been discontinued, so we have issues with things like 64 bit support, Windows 8 and so on. We also have some 'home brewed' tests, and they are proving to be a nightmare to support, plus I'd sooner we build Uniface features, not a testing tool. Anybody out there in customer land using testing tools, this is for repetitive tests? (screen scraping which is then played back. If so, what, and any details to share on what experiences using them have been, any details on why a particular product was chosen and so forth. Also happy to discuss on the phone, receive emails and so forth.

Uniface MS - SQL remote database connectionAuthor: stephane.allam@issa.ch (StephAll) Hi All, Did someone actually performed a connection to a remote MS-SQL from uniface?   Stéphane

Fatal error: 8011 - License not available.Author: gillian.bendel@frontline-consultancy.co.uk (gf07) I am new to Uniface and have installed a trial version of Uniface 9.2.02 Development on a Windows XP Professional SP3 PC. I have added my licence file to the DLM in the local environment tab. All the licence features have displayed ok (status is ok) and has an expiry date in September. However when I try to open any of the programs like Uniface Deployment I get the error "Fatal error: 8011 - License not available".. During installation I got the warning " An error occurred creating account for userver" and " An error occurred creating account for urouter". I am not sure if this is connected to the licence error or if it is separate. Does anyone have any suggestions please as to how I can resolve the licence error? Thanks in Advance

Uniface 9 title barAuthor: None (None) The "Files" area contains an easy work around made by Daniel Iseli (thx!) from Uniface technical support. With this solution you can use the logical UDE_APPLTITLE in your assignment file to set the text in the applications title bar. This software is delivered "as is" no rights can be derived from it. Implementation in future Uniface version is considered.

Case in-sensetive searchesAuthor: sbpatel48@gmail.com (Sandip) Hi, We are using Oracle, and I'd like to carry out case in-sensitive retrieves. I've got part of the way there, by using : sql "ALTER SESSION SET NLS_COMP=ANSI","DEF" sql "alter session set NLS_SORT=BINARY_CI","DEF" However, this only works correctly if the complete text is typed, and doesn't appear to work if wildcard * is used. ie Value of the db 'TEST' if i type 'test' and retrieve i get back the 'TEST' record. Type 'TES*', i get the 'TEST' record back but if i type 'tes*, i don't get anything back. Anyone got any ideas, pls. Sandip