Uniface® Forum Home

[SOLVED] SQL Server 2016 supportAuthor: stijn.courtheyn@xperthis.be (Stijn Courtheyn) In which future version of Uniface will support SQL Server 2016? Can we already use it with driver MSS 5 ?

[SOLVED] handling data acquired by barcode readerAuthor: mail@gandg.it (TheAleph) I  all,  I'm using U 9.4 In a form I create a field that displays data from a barcode-reader, can't find a way to handle it without CR or sending, that I have to run the trigger when the field is enhanced and then clean it up and stay waiting for a new reading. Thanks

search in structAuthor: yves.de.montmollin@aonhewitt.com (yves2m)  Hello, My question is very basic. But I can't find the answer ...   I know I've seen this before ... but where ...  I've a struct : vStruct->$dbgString []   [paramsOut]     [requestResult]         [endOfCollection] = F         [firstRowInCollection] = 5         [lastRowInCollection] = 10         [requestStatus] = 0     [collection]         [OCC]             [PE_ASSU_ID] = "350288"             [NOM_ESTE_1] = 437             [PE_PERS_ID] = "329400"             [DADVAL] = 20130823             [NPERSO] = "555891686"             [LPNPER_UPPER] = "ALEXIS&quot

How to insert info into different DBs through a RESTful web service (DSP) called from a wordpress site.Author: juanchoibf@gmail.com (juanchoibf) Hi everyone, i hope someone can help me with the following information: At the company i work for we have a wordpress website with several subdomains for each country we give our services. Currently we are unable to connect directly to our system data bases from this website, so i am in the making of a RESTful web service with a DSP to achieve this needed communication.  So, every country has a web form to send information to its respective data base, the thing is: How can i specify dynamically the Data Base where i need to insert this information through a DSP web service, if it is common for all the countries?. I hope i was clear enough to give you guys the basic idea of what i want to achieve.   Cheers,  Juan Bigorra

[SOLVED] MY SQL ConnectorAuthor: nei.fassula@dnacode.com.br (neifassula) Hi all, I got the uniface 9.7 version and I'm trying to run some tests using the MY SQL database, but when I retrieve an entity, I've got the below message: Unable to load umql21; error 126 ('Não foi possível encontrar o módulo especificado.') *** The DLL could not be loaded either in the USYSBIN directory or via the PATH variable. *** Check if its directory is in the correct place in the PATH variable. Current PATH shown below. I tried to use the driver settings: MQL U2.1 MQL U3.0 MQL U4.0 All of then returned the same message. Environment: uniface = 9.7 last release MY SQL = 5.6 Windows 10 Any idea about what is missing?   Many thanks  Nei

[SOLVED] No widget creator found for . Are you missing a Javascript include?Author: lammersma@hotmail.com (lammersma) Hi,   In runtime a DSP shows: "No widget creator found for . Are you missing a Javascript include?". Strange, because the component always worked fine and was not changed since april this year.   Any idea's where I can start searching for a solution?   Thanks, Peter

Automation of uniface application using Coded UI automation toolAuthor: nandkumar.pakhale16@gmail.com (NandkumarPakhale) Hello Team As part of my test automation I need to automate one of Uniface application. Currently I am using VSTS Coded UI for automating other web applications, In order to automate uniface application with the existing framework which builds on VSTS coded  it seems there is a potential problem in object identification.we can not able captured the control using coded ui builder  Can anyone helps us to identify the controls uniquely from uniface application or do you have any pointer how we can achieve automation of uniface application using coded ui  Regards, Nandkumar Pakhale 

^ZOOM,SMOD, detect GRID widget use Author: vojta@incad.cz (vojta) GRID widget doesn´t support ^zoom, and some other behavior is changed. I try to replace this functionality by using cursor menu and uniface form. But when user try to edit and save field value this solution doesn't respect •field NED,$editmode=2 .. but it can detected by uniface functions. •SMOD triggers ,  returning value<0 So it is not possible fully replace  ^zoom with this solution. Zoom implemented by this way must be  display only , or there must be special mechanism to secure field value. Is there any way, how to detect GRID widget use ? is used( ^ZOOM doesn't work, must be replaced) Is there any way, how programatically start SMOD to check its value.. ?  Thanks for any ideas

Direct and quick export Datas from an Uniface form to ExcelAuthor: daniel.cabero@euralis.com (cabero) We have performance problems during export Datas from our Uniface forms to Excel. We simply concatenate the fields of the forms in a special "big" field. So, after that, we can filedump this field in file in text mode. and then we open this file directly with Excel. But this method has several disadvantages: -> In case of numerous occurences, this export is VERY long -> if the data , (even if it's a field types Character)  start  with '- ' or '+' or '0' , etc,  o Excel interpret the column as a numeric field I Tried to use: ComponentToStruct and then StructToXml to filedump the XML file. But I have errors in Excel while opening the xml file created.   Is anyone have a solution to export directly, simply and faster, the datas of Uniface forms to Excel  ? Thanks in advance for any help

$LFILEPROPERTIES MODIFICATIONDATEAuthor: i.sharp@pcisystems.co.uk (Iain Sharp) We have an automatic update system to update the customers, which compares MODIFICATIONDATE of the file on our server with the same property of the file on the customer server.  When the clocks change for BST over GMT, all the modfication dates of the files on the server jump by an hour, meaning that they are all needlessly updated to all of our customers.  Is there a way to get the modificationdate of a file in GMT or UT? It does not seem to matter whether the file is created during GMT or BST, they all jump by an hour on change of dates.    Iain

Order of CLEANUP if using SOAP-servicesAuthor: i2stiller@gmx.de (istiller) Hi freaks Writting SOAP-services I run into a "little" problem: In which order will UnifAce destroy instances? A SOAP service itself will be initiated on call a operation by UnifAce and be destroyed after leaving the operation. All other (non attached) instances will be stay alive until the UROUTER/USERVICE will be stopped. As we create a "heavy" environment when start up the SOAP-service at first time, I don't want to destroy this environment every time the SOAP-service returned to the caller This I can handle without a problem, BUT ... But if the UROUTER stops the USERVICE, Uniface will delete all open instances in a random order. No changes to shutdown the envirnment in a proper way Is there a solution to fire a CLEANUP-ahead before the instances will be destroyed and/or can sepcify a order of this deletes? TIA Ingo

Save GLYPH as ImagefileAuthor: lorenzen@ahp-gmbh.de (lorenzen) Hallo, we use a HTML-Grid-Widget to display dynamic Overviews in our Application. To include Glyphs in this overview it is nessasary to get them as BASE64 String. Is there a way to convert a .gly files from the UOBJ.DOL file to a BASE64 String or the original Imagefile? Or is there another way to get a glyph as image?   Thanks for help

Model analyzer and related checksAuthor: claudio.palladini@cortislentini.it (Claudio) Hello everyone, I'm just getting started with Uniface (in my case 9.3) and, playing with Model Analyzer, I found that it does not report problems in case I have defined a foreign key between two fields that have a different type. Classical example: relationship between a char field with and a number field. In a logical relationship I could be agree with M.A., while leaving to the programmer the entire management of the relationship, though could give me at least a hint. In a physical relationship where I want to use a referential integrity constraint, I would expect that Uniface print automatically (and directly send to my boss) the letter of resignation. Seriously, in my Uniface version the M.A. don't make this kind of check, there is an option in environment to ensure that the M.A. to perform it? Thanks all Claudio

[SOLVED] CryptographyAuthor: dammie@seznam.cz (dammie) Hello, I ve tried encrypting in uniface that i ve founded in documentation help but none of examples is working :( EXAMPLE 1 variables string vEnc raw vrawdata endvariables   vEnc = $encode("BLOWFISH", "~home", "secret key") ;encrypt the data vRawData = $decode("BLOWFISH", vEnc, "secret key") ;decrypt the data klic = $encode("USTRING", vRawData) ;convert the decrypted data from Raw to String   "ERROR=-1791·; MNEM=<UENCERR_GENERAL>·; DESCRIPTION=Encode/decode general error·; COMPONENT=AA0006XO·; PROCNAME=6\\DTLF·; TRIGGER=DTLF·; LINE=3·; ADDITIONAL=StreamTransformationFilter: ciphertext length is not a multiple of block size"   EXAMPLE 2 # Generate the RSA private key in the traditional SSLeay format. openssl genrsa -out traditional.pem 2048 OK # Change the private key to PKC

Setting Uniface value depending on Javascript functionAuthor: jon-butler@softwareimaging.com (jonb) I'm a newbie to Uniface so my apologies if I should know this.... We are creating a DSP, then exporting the HTML and transforming it so that it can be displayed in several themes (e.g. a long table list on desktop, and a single occurrence for mobile). I have uniface proc code to retrieve a certain number of records and also to display page numbers (for the desktop), and Next/Prev buttons for mobile. My ideal situation would be to have a single control which would use a Uniface variable to determine if I need to read many or 1 occurrences and similarly a single control which would either create and support page numbers or create and support next/prev page controls. Is there any way in which Javascript code can call Uniface to configure these settings? I have looked at the Uniface documentation and not found anything which I can be sure of.   Happy to clarify this if

[SOLVED] Uniface debugger halting on change?Author: gianni.sandigliano@unifacesolutions.com (gianni) Hi Unifacers, I am looking for a confirmation here: I was asked if Uniface debugger can halt automatically on value changed of a specific object like: - global variable (library.$$name) - component variable (component.$name$) - module variable (name) - model (modelname) - entity (modelname.entityname) - field (modelname.entityname.fieldname) As far as I know the answer as of U9.7.01.G104 should be NO; more or less complex workarounds are possible like: - reducing context than putting a breakpoint on few components where that object is used - activating tracing and analyzying trace log later on Any more thoughts on this subject? Thanks for any input! Gianni

Open Widget InterfaceAuthor: gianni.sandigliano@unifacesolutions.com (gianni) Hi Unifacers, I digged in all my documentation (and I have a lot!) but I haven't find anything; probably it went in the wild when my previous PC suddendly crashed few years ago. Where can I find more informations about OWI? Thanks for any input. Gianni

RESTFUL web service with server certificate using UHTTPAuthor: fearandir@gmail.com (fearandir) Good morning everyone.   Currently, we are working with a bunch of restful web services that NOW are implemented over a secure, encrypted HTTPS connection using a SERVER SIDE certificate. Not client certificate required.   The authentication is made, providing the user and password inside the SOP header. You can see the encoded user and pass:    newinstance "UHTTP", VUHTTP getitem/id VS_URL, PSI_IN, "ENDPOINT" VSSECURITY = $encode("BASE64","%%VS_USER:%%VS_PASS") putitem/id PSO_HEAD, "Authorization", "%%VS_AUTH %%VSSECURITY" PNO_STATUS = VUHTTP->Send(VS_URL,"GET","","",PSO_HEAD,PSO_BODY,PSO_RESP)  I got a funny $STATUS=0. The SEND help page do not cover this returned status...   So i followed the secure https connections guideline: Add the certificate information into a file ca

[SOLVED] Conditional compileAuthor: i2stiller@gmx.de (istiller) Hi freaks Just a simple question How to compile parts of code depending on the existence of fields? Background: Say, you have a few fields which are sometimes defined as database fields in a table, but sometimes not. Table A1     Table A2   Table B FLD_A11     FLD_A21   FLD_B1 FLD_X        FLD_X      FLD_B2 FLD_A12     FLD_A22   ... ... FLD_X is only present in A1 and A2 but not in B (and this schema goes on for a few 100 other tables) Now I got a proc-include for all the tables, in with (if exists) I want to calculate the sum of FLD_X selectdb sum(FLD_X) from <$entname> u_where (...) to v_SUM If FLD_X not in entity $entname, Uniface will not compile this statement What I'm looking for is something like #ifexistfield FLD_X.<$entname>   selectdb sum(FLD_X) from &l

naming conventionsAuthor: i2stiller@gmx.de (istiller) So, now I'll start a survey Is out there any preferred naming conventions of operations? As in other languages I named an operation which does some display "DISPLAY" and another one printing will named "PRINT". So an activate looks like: activate v_INST."DISPLAY"(...) or v_handle->"DISPLAY"(...) But the disadvantage is, that UnifAce editor highlights this like any other "display" statmenent. So I thought about OP_DISPLAY, OP_PRINT, OP_xyz, ... And as will all know, one drawback of UnifAce is, there is no overloading of functions. Say, there is the need for two PRINT-Operations OP_PRINT(a_parameter_typ1) and OP_PRINT(a_parameter_typ2) Okay, the only solution so far in UnifAce is two write two Operations OP_PRINT1 and OP_PRINT2   So the survey is:   how do you name operations in general?   how do you name such overloaded functions? Any hint / commen

UXMLREADER on Application server not available?Author: dammie@seznam.cz (dammie) Hello,   I created comp service for loading xml, if I run it on my local pc it runs ok... but if I run it on application server after activate i v got error -57 :( newinstance "UXMLREADER", vReader activate vReader.setHandler($instancename)   -57 UACTERR_NO_INSTANCE The named instance cannot be found in the component pool. Any hint? Thanks.. :(

[SOLVED] Nice coding - can I define something as function module on form? Author: dammie@seznam.cz (dammie) Hello, in my code I can use this : call L_my_proc_get_state ( ln_state ) if ( ln_state ) ... do something   I would like use more nice and readable command as this... if ( $my_function_get_state ) ... do something   Is there any way to do this on form or how to get it with proc / operation more nicely?   Thanks for tips..

Tabs on FormAuthor: dammie@seznam.cz (dammie) Hello, I´d like to use tab widget ... Form with tabs widget had to be Non-Modal ... There is pool of modal forms, if I want to call this non-modal form  I ve got this error... :(   -60 UACTERR_ACTION_ON_MODAL_FORM An attempt was made by an instance other than the current modal form instance to start an operation other than the EXEC operation. There is non possibility tu run non-modal from modal or how or how can I cheat it?

Load and resize images in a DSPAuthor: nei.fassula@dnacode.com.br (neifassula) Hi all,  I'm uploading images via DSP component using the dropzone sample posted by @jtsagara and it is working well, but I want to resize de image during this process. Does someone know how to resize an image when uploading via DSP? Cheers Nei

How to avoid TableName_SEL# error Author: dammie@seznam.cz (dammie) Why I ve got this error ?? Server: I/O function: S, mode: 0, on file/table: TableName index: 3 = Server: Stored procedure 'TableName_SEL3' not found.  There is only PRIMARY KEY and no index defined in model. So only TableName_SELECT should be generated... Analyse of model not helped... export/import of cif as well... :( Is there some internal error of IDF?