Rocket MultiValue

We turn on work wrap in our Grids. However, we would like to programmatically force a line feed in a cell of the grid. We have not found the character to use to force this to happen. we would typically do: tmp.tab<1,row.ptr,col.ptr> = data.record<1,1>:data.record<1,2> we would like the data.record<1,2> to be on the second line in the cell of the table we have tried the pipe character (such as Combobox in a grid column).  Have not found this in the manual and/or several places online.------------------------------Jesse TilliaProman-ERP, Inc.West Seneca NY US------------------------------

One of my customers has several users who work on both the workstation at their desk and from other locations on a laptop.  Will the Personal installation allow for a single seat to be used for installations on two machines as long as they are only using one at a time?  Or will they have to use the Portable installation on a memory stick? Dale------------------------------Dale KelleyI'm it!Dale W Kelley IncHohenwald TN US------------------------------

I've noticed that a number of lppick processes are hanging around long after they should have exited.  I've seen this in v9, but I figured it was just a bug that would get resolved with v10.3.4.  Apparently not. :( Example: In the past, I've just killed these processes but before I go about that this time, I wanted to find out if there was something I can do to ensure that it doesn't keep happening. I should note that this isn't isolated to one of my plants - here's the list from my other plant: Both hosts are on RHEL 9.4 and using D3 v10.3.4. What do I need to do in order to keep these orphan processes from stacking up? Thanks folks! g. ------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

Hey, guys. new here. Programmed PICK and Unidata back in the late 80's / early 90's and I'm REALLY rusty. Can anyone tell me where to find a Dict Reference Guide?Thanks much- Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

I have installed the DBTOOLS BASIC DEVELOPER TOOL KIT but I am having issues. Here is some info and a couple of issues I am having and would like some suggestions or advice on what to do next or what I may have done wrong.  We went through the install steps and see these were installed. The BDT launches but fails to update the subroutines. I set permissions on the folder to /usr/ibm/uv/BP.O to write for everyone but it still fails. When connecting I get the following messages and click OK to update. I have set the permissions to the folder so that everyone has write permissions but still get this error. Since the program launches, I decide to try something simple like opening a program but get this error. The source code does exist in file of the shown in the VOC of CK.DATE. Thanks in advance for any assistance.

I have one user who has severe mouse problems inside a spreadsheet that has been executed from AccuTerm.  If the same spreadsheet is opened from Excel itself or from the file explorer, everything works normally.  The problem is a severe lag in any mouse commands.  If the user clicks on a cell, it is 2 to 5 seconds before the cell that was clicked on becomes selected.  If the user tries to drag a selection in order to select multiple cells, there is also a severe lag. The user is on the latest version of Accuterm I have which is 8.1.2.1137.  The mouse pattern file is identical to what I and other people are using. Has anyone encountered this before?

We run d3 on an Windows Server 2008 Can someone describe how to move d3 to a new server (windows 2012)? eg;  Download installer to create the d3 environment Move live data from current server to new server. Explain how the license which allows the application to run is transferred to the new server. Thanks, Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

This is probably an easy question for someone but I dont know the answer. I just switched to a new job and their wildcards seem to be prime like instead of PICK like...for instance - where I used to type 'SELECT VOC = "[KH]"' they are typing 'SELECT VOC WITH @ID LIKE "...KH..."' Can someone tell me if this is a UDT option? term type? some other setting that I can adjust? I can of course just get used to the new syntax but was wondering why it is different. Thank you Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Hi   I am now starting to role out the Accuterm Front-end developments, we purchased 3 licenses 12 months ago and have only used one.  Yesterday I tried to Activate a new terminal as the second of our terminals but    The activation screen just says  Internet access required at bottom - yes it has internet access but the Activation Button is grayed out   🙁 Can anyone help please  Many Thanks Chris Baxter------------------------------Chris Baxter MDCB SoftIPSWICH GB------------------------------

Hi, Recently upgraded a site to Unidata 8.3.1 on Win Server 2022. Tried running Phantom LISTUSER at ECL Failed to start PHANTOM.Phantom execution failed. checked permissions user has full control What trouble shooting can anyone recommend. Thanks ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

hi, May I introduce a suggestion to help the program runtime to check the type of a variable and not crash. There is already a function DESCRINFO(1,variable) which return the type of the variable ; so some type c.f. descrinfo() doc ref  on sellist, pyobject, udo, do, xdom, ... descrinfo() return -1 ...  I'll suggest to implement more descrinfo result value like 11=sellist, 12=pyobject, 13=udo, 14=do, 15=xdom, ... and by extension, if request_code = 2,  descrinfo return a DO with polymorph properties aka. metadata about the variable.  with kind regards------------------------------Manu Fernandes------------------------------

hi, when I try this : var = '' try var->$objecttype() catch e print 'error ':e->$tojson() endtry print 'finished' the error is not cached, the program terminate with echo bad self type: 2 and @SYSTEM.RETURN.CODE = -1  Same behavior with the $fromjson(), $tojson() ...  any idea ? ------------------------------Manu Fernandes------------------------------

Is there a way to send an excel formula through a D3 dict item in an FTD command?------------------------------Colleen SiscoConsultantBusiness PC Consultants IncUpper Black Eddy PA US------------------------------

Hi, Recently upgraded a site to Unidata 8.3.1 on Win Server 2022. Tried running Phantom LISTUSER at ECL Failed to start PHANTOM.Phantom execution failed. checked permissions user has full control What trouble shooting can anyone recommend. Thanks ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

on a READU the STATUS() function is returning the incorrect value for the userno if the record is locked but a phantom.  Instead of a negative number is returns the number without the minus sign.  Has this been addressed ? 0001:       OPEN '','INCIDENT' TO FILE THEN                                     0002:          READU X FROM FILE,'21333' LOCKED                                 0003:             PRINT STATUS()                                                0004:          END ELSE                                                         0005:          END                                                              0006:       END                                                                 0007: END                 ? LR                                                                           Account  File        UNO  PID   User       Record Id            Date  Time      -------------------- ---- ----- ---------- -------------------- --------------  KOPS     INCIDENT    -8   9324  

My customer, UniVerse 13.5, is running on Nashville Metro Government's internal cloud.  The network security is so restrictive that it is difficult to get work done for the customer.  I have requested information from the "mypickcloud" website but have received no response.  Does anyone know if that cloud still exists and if so how to contact them.  If they do not exist does anyone have recomendations on other clouds where UniVerse could reside?  I have looked at AWS website and am buffaloed by the complexity of their options.  I would simply want to move my customer's system and data to a cloud server for day-to-day operations. Dale

The Rocket® MV team is pleased to announce the availability of UniObjects for Python (UOPY) v1.4.0 on January 22nd,  2025. UniObjects for Python offers a wide range of benefits including: An open and extensible UniObjects client Remote access to MV servers in Python, great for developers who aren't familiar with BASIC Full stack development in Python: from web server (UOPY) to database backend (U2py) Ability to leverage the Python ecosystem including many 3rd party libraries Rapid application development UOPY v 1.4.0 enhancements and bug fixes: Enhancements Certification of UOPY on Python odd version numbers (3.9, 3.11 and 3.13) and paper certified UOPY on Python even version numbers (3.10, 3.12). Introduction of the ClearPool functionality in UOPY to facilitate the termination of all open pool connections. This functionality uses the closeAllCPSessions() method, to close down all open sessions in the UV server spawned by UOPY. Bug Fixes  Support for MVIS Connection Using UniOb

The python 'dict' object is ubiquitous when interacting with python modules, functions and classes. The process to create a python DICT object using the U2 BASIC Python API is, well, interesting: Create a LIST containing just the 'name' and 'value' for the DICT entry Create a TUPLE from the list Append the TUPLE to another LIST that will be used to create the DICT When the LIST of TUPLE objects is completed, create a DICT using the LIST of TUPLES This all works ok for strings and numbers, but I cannot get a boolean True or False value to use in the tuple. I either get an integer value of 1, or 'None'. This is the code I have tested so far, trying to get a python True object/value: ** Attempting to create a python True object using the PyBASIC API pmo.BUILTINS = PyImport("builtins")if len(@PYEXCEPTIONTYPE) then gosub PY.BADNESS * Using CallMethod to run the "bool(x)" commandtest1 = PyCallMethod( pmo.BUILTINS, "bool", (-1))rslt = PyCallMethod( pmo.BUILTINS, "print", 'test1', test1) *

Hi Expert, I am new to U2 and the EDA Schema Manager tool. I am trying to import data from U2 files into a SQL table using EDA. I have successfully created an ODBC DSN connection and installed the EDA. Additionally, I connected to the U2 server and can see the schema files. However, I am encountering issues with the EDA Source connection.  I correctly created the connection, but when I validated it, I received different error messages each time. Here are the error details: 1. EDA license not authorized.2. Map Schema __CURRENT_MAP_SCHEMA__ failed on lex check.3. Could not write the data source (Connection Name) on Server (U2Server). Could you please advise on the reasons for these errors? Is it a license issue, and if so, how do I obtain a license? Or could it be a configuration issue? I would appreciate your help. Thank you! ------------------------------Marimuthu kalyanasundaramMRRocket Forum Shared Account------------------------------

After being unsuccessful installing the server side of AccuTerm 8 either from my Cisco VPN connection or from a local to the network workstation, Metro's IT department suggested that I install the AccuTerm client onto the server and try the "install server" step from there.  The results have been pretty much identical.  I have copied some screenshots below.  The process has completed only the establishment of the FTBP directory and the installation of FTPBPINST into that directory.  This leaves me with three questions:  Has anyone been successful in installing the server side of AccuTerm on a windows, (2022) server?  Is the windows server just not possible?  Is there a manual step by step process that I can follow to make this installation?  I sure would appreciate some help. Dale Thanks

We are excited to announce the release of U2 Toolkit for .NET v2.2.3 on Thursday, December 16th. U2 Toolkit for .NET version 2.2.3 is a Provider release which provides a comprehensive ADO.NET provider, LINQ to Entity provider, and the native UniObjects for .NET API for the U2 databases. U2 Toolkit for .NET is optimized for connection performance to UniData or UniVerse. The U2 Toolkit for .NET Provider is a suite of data-access technologies that are included in the .NET Framework class libraries.U2Toolkit for .NET v2.2.3 enhancements include: Support for .NET Standard 2.0 making the U2 Toolkit for .NET Provider compatible with .NET Framework 4.8, .NET Core 3.0, and .NET 5 Support for Visual Studio 2019 providing support with for .NET Framework 4.6.1 and later Additionally, v2.2.3 includes 19 bug fixes as well as 3 other enhancements.U2 Toolkit for .NET is a free tool now available through Rocket Business Connect (RBC).  ------------------------------Christine RizzaMV Product ManagerR

After I converted to Windows 11, FT.IMPORT now hangs after the message "Converting spreadsheet.xlsx from Excel format for upload...".  I use this program constantly.  I'm also having some freezing issues when I use subroutines that show a GUI window.  I found the thread "Accuterm GUI lockup on windows 11" which strongly suggests upgrading to at least 8.0.1123 or 8.0.1127 as those versions have fixed some Windows 11 problems.  I currently have version 8.0.1023.  Is it likely that upgrading would solve the FTIMPORT problem too?------------------------------Steve HenkelDirector of ISRocket Forum Shared Account------------------------------

I posted something similar to this in this thread: Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData Hi allI have some problems when connecting to servers using uopy, as the PATH variable is wrong.From the terminal console:>SH -c "echo $PATH"/usr/local/bin:/usr View this on Rocketsoftware > I have a variable defined in /etc/environment: [hcortiguera@catalogo20 ~]$ cat /etc/environmentOPENAI_API_KEY=MY_API_KEY I can read it from command-line Python: [hcortiguera@catalogo20 ~]$ /u2/uv/python/bin/python3Python 3.9.2 (default, Jun 15 2021, 01:30:50)[GCC 4.8.5 20150623 (Red Hat 4.8.5-36)] on linuxType "help", "copyright", "credits" or "license" for more information.>>> import os>>> os.environ['OPENAI_API_KEY']'MY_API_KEY' But I can't read it when I call Python from BASIC NOMBRE.VAR.ENTORNO='OPENAI_API_KEY' NOMBRE.SCRIPT='consultaVariableEntorno'NOMBRE.FUNCION='get_var_entorno' RESPUEST

We're looking to upgrade to jBASE 6.2.1.1 but ran into a problem with printed output.  I believe I can solve this problem using SP-TRANSLATE.  Is there documentation more specific than what I could find on the website?  I would like details how to create the translation table and where it should be stored.  Thanks. Jim Edwards------------------------------Jim EdwardsIT ManagerPlimpton & HillsMeriden CT US------------------------------

Hi, Does Unidata 8.3.1 or greater support TLS 1.3 protocol, I understand it support TLS 1.2. Thanks ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------