MultiValue Tools

Enhancing Your Development Experience with New Features and Fixes in Rocket Software MV BASIC for VS Code 2.7.0 In the ever-evolving world of software development, staying ahead of the curve means continuously improving tools and workflows. We're excited to announce several new features and enhancements that will significantly boost your productivity and streamline your development process when using Rocket Software MV BASIC for VS Code. Separate Compile and Catalogue Option One of the standout features in our latest update is the separate compile and catalogue option. This enhancement allows developers to compile their programs independently from cataloguing them. By decoupling these processes, you gain greater flexibility and control over your development workflow. This means you can compile your code, test it thoroughly, and only catalogue it when you're confident it's ready for deployment. This separation helps in reducing errors and improving the overall quality of your software.

Hi, I can see online documentation refers to The EDA SQL Server driver supports SQL Server 2014 and greater. Is there a driver to support SQL Azure. Thanks------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Greetings, y'all! Is anyone aware of ERP/MRP systems available to the automotive aftermarket or performance auto parts? As always, thanks for your helpful replies... ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi sb users, I'll share a vsCode extension to edit Sbparagraph code.  Use a trigger on XXPROCESS to sync P type in a Directory.  Use sftp/sync to have it on the client Edit your code Use a ssh RUN program to sync back, copy into XXPROCESS, regen the process (like f2), run GC. It return ProblemMatcher info.  Capabilities : syntaxe coloris, all sb common vars, all SBExpression, all sbSubrs, Formater (indent), Hover, SignatureHelp. You can provide custom intellisensitems for Hover and Signature Help. I share all my expérience with pleasure.  Manu------------------------------Manu Fernandes------------------------------

Recently a survey was sent to MVIS customers asking to provide the following usage information: API request volume:- Average number of API requests per day:- Peak number of API requests per day:- Total number of API requests in the past 30 days: Data volume: - Average size of data per request (in KB or MB):- Total data transferred via API in the past 30 days (in GB): Usage patterns:- Typical hours of peak usage (e.g., 9 a.m. – 5 p.m. UTC): One customer logged a support case asking how they could extract the information from the MVIS logs. I believe that the following information can be extracted from the "Perfstats_PER_REQ.log" which is created if you enable performance monitoring in all versions of MVIS. API request volume:- Average number of API requests per day:- Peak number of API requests per day:- Total number of API requests in the past 30 days: Usage patterns- Typical hours of peak usage (e.g., 9 a.m. – 5 p.m. UTC): The basic program "MVIS.REQUEST.TOTALS" (See below) should re

As I wrote in another thread I'm connecting to a database using a custom account. The account's path is: /u2/quiter/POSVENTA5 In that path I open a file, for example: /u2/quiter/POSVENTA5/BP/ACCSCR0 Then I try to click on another definition (ACCSCR0) to open it: * Carga datos IF HAY.AUTOFILL=1 THEN CODIGO.ED=XDATO * Lee registro CALL ACCSCR1(MAT XQ,MAT XXQ,XK,XMACRO,MAT XFIELD,XA,XV,XRESUL,MAT ENTR,XSTACK) END ELSE The editor then tries to open the file in /u2/quiter/POSVENTA5/ACCSCR1 instead of /u2/quiter/POSVENTA5/BP/ACCSCR1 so it fails. How can I fix the search path for the editor? Is there a way to do something like this: https://rocketsoftware.github.io/rocket-mvbasic/usage/Catalog/ for online editing? ------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

We're excited to announce the availability of the Rocket® MultiValue Developer Assistant. This AI-infused assistant enhances MV BASIC proficiency and developer productivity. See below for key features and requirements. For more details, read the Developer Assistant datasheet and register to gain access. The MultiValue Developer Assistant version 1.1.0.0, integrated within the VS Code® Integrated Development Environment (IDE), allows you to: Generate MV BASIC code via natural language queries. Autocomplete MV BASIC code. Explain MV BASIC code in natural language. Generate comments for existing MV BASIC code. Developer Assistant essential information: Program delivery: Hosted by Rocket Software in AWS and free with an MV data server (UniVerse, UniData, D3, jBASE, or OpenQM) serial number on active maintenance. Requirements: Visual Studio Code and internet access To sign up, please complete the registration form. Check out the product availability matrix in Rocket Business Connect (

We just upgraded one of our Universe servers to 11.4.1 and i'm trying to set up the MVVS extension in Visual Studio Code to connect to remote Universe. I installed extension Rocket MV basic version 2.7.1 set up db.mvbasic.json with: "db:{       "host": "xxx.xxx.xxx.xxx",      "userName": "xxxxxx",       "password": "xxxxxx",       "account": "XDEMO",       "dataSource": "UNIVERSE",      "port": 31438 } When I attempt to F1 -> Connect/Disconnect U2 Server,   nothing at all happens.  I see in the extension Runtime Status: Uncaught Errors (11)  Pending response rejected since connection got disposed  Client is not running and can't be stopped. It's current state is: starting  Client is not running and can't be stopped. It's current state is: startFailed  Pending response rejected since connection got disposed  Client is not running and can't be stopped. It's current state is: startFailed  Client is not running and can't be stopped. It's current state is: startFailed  Client is not run

Hi all I'm trying to connect to our database using the Visual Studio Code extension. I've configured the server data in the JSON file, but it's connecting to a XDEMO account so it's not useful to me. So, the account is XDEMO and it connects to the server in this path: "/usr/uv/XDEMO" In our database, we have several accounts: "POSVENTA5", "GEN4GL", etc. I need to connect to one of this accounts, that are in the path "/u2/quiter/POSVENTA5", etc. How can I do this?------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

Attempting to assign this click to a keybinding I guess it's supposed to be "vscode-rocket.mv.basic.command.online.server.connect" but the command registration appears to be broken... ------------------------------Stuart BoydellAU------------------------------

I have been struggling this for a few days now. This works of course in Terminal. When you right-clock on a program in VSCode, the bottom  two menu items are Catalog and Compile. I have researched this and it would seem several configurations need to be in place.  I do have the ssh configs set up, the BP file in the workspace, but it never finds the file or the program. Does anyone have the steps to rectify this? Thanks in advance,  Roy.

🧠 Jump to Top in Multi-Value Fields – A Simple Trick to Loop Input Have you ever faced the challenge of designing a screen with a fixed number of multi-value lines, and wanted the cursor to jump back to the top once the last line is reached? For a long time, I couldn't find a way to do this. But now I've discovered a simple trick-and I'd like to share it in case someone else has the same need. 🔧 Scenario Imagine you have a screen like this: You want the cursor to jump back to the first line when pressing <Enter> or <Down> on the fourth line. 🛠️ How to Implement It In the Process Before of the MV field, set: (P:@REFRESH = -2) In the Controlling/Dependent Options, press F3 on Control/Dep/Read and enter the following in Process on MV Disp: 4 is the number of maximum MV lines you want. the 1 in /1.1 refers to the StepNo of the field you want to jump back to (in this case, line 1 of field 1). 💬 Final Thought I just wanted to share this idea with the SB community-thanks

Hi sb users, I'll share a vsCode extension to edit Sbparagraph code.  Use a trigger on XXPROCESS to sync P type in a Directory.  Use sftp/sync to have it on the client Edit your code Use a ssh RUN program to sync back, copy into XXPROCESS, regen the process (like f2), run GC. It return ProblemMatcher info.  Capabilities : syntaxe coloris, all sb common vars, all SBExpression, all sbSubrs, Formater (indent), Hover, SignatureHelp. You can provide custom intellisensitems for Hover and Signature Help. I share all my expérience with pleasure.  Manu------------------------------Manu Fernandes------------------------------

Hello, In MV Basic for Visual Studio, can you compile within the program?  For example in Accuterm WED your press F10 and it compiles displaying any errors or a successful compile.  Thanks.------------------------------Peter GonzalezSt. Louis, MO US------------------------------

We're excited to announce the availability of the Rocket® MultiValue Developer Assistant. This AI-infused assistant enhances MV BASIC proficiency and developer productivity. See below for key features and requirements. For more details, read the Developer Assistant datasheet and register to gain access. The MultiValue Developer Assistant version 1.1.0.0, integrated within the VS Code® Integrated Development Environment (IDE), allows you to: Generate MV BASIC code via natural language queries. Autocomplete MV BASIC code. Explain MV BASIC code in natural language. Generate comments for existing MV BASIC code. Developer Assistant essential information: Program delivery: Hosted by Rocket Software in AWS and free with an MV data server (UniVerse, UniData, D3, jBASE, or OpenQM) serial number on active maintenance. Requirements: Visual Studio Code and internet access To sign up, please complete the registration form. Check out the product availability matrix in Rocket Business Connect (

Hi facultative code folding in vscode languages is a good productivity thing but not enabled by default for the Rocket mvbasic extension. It allows you to hide unimportant code in the editor not already hidable because of indentation. The language-configuration.json configuration file allows for a folding region to be added/enabled. This is the json snippet I manually edit into the client and server config files. "folding": { "offSide": true, "markers": { "start": "^\\\\s*!!\\\\s*#region", "end": "^\\\\s*!!\\\\s*#endregion" } } Could we get default folding markers added please. ------------------------------Stuart BoydellAU------------------------------

We're announcing today the availability of wIntegrate 6.4.5. For more details on this latest version, check out the product availability matrix in Rocket Business Connect (RBC). Version 6.4.5 adds certified support on both Windows 11 and Windows Server 2022 along with enhancements and defect fixes. You can find additional details in the 6.4.5 release notes. wIntegrate 6.4.5 PLC dates: 29 Jul 2025 GA 29 Jul 2028 EOM 29 Jul 2029 EOS 29 Jul 2030 EOLS ------------------------------Hernando BordaPrincipal Product ManagerRocket Softwarehborda@rocketsoftware.com------------------------------

We're thrilled to introduce the Rocket® MultiValue Integration Server (MVIS) 2.2.1, a release that reflects our ongoing commitment to delivering smarter integration, stronger security, and a smoother experience for you. The MVIS team has worked diligently to bring meaningful improvements that simplify workflows, enhance visibility, and reduce friction in day-to-day operations. Seamless MVConnect Integration MVIS now supports direct integration with MVConnect, allowing you to run MVConnect programs as REST endpoints from within MVIS. This enhancement eliminates the need for complex configurations and accelerates deployment, making it easier than ever to connect MultiValue data servers to modern applications. Enhanced MVConnect Request Handling MVConnect requests now run directly through a UniRPC connection to the MV dataserver, improving performance and reliability. New users can deploy the MVDB account directly, while existing users can enable this feature by cataloging two new subrout

Hi folks, I'm new to Windows servers have mostly used AIX, HP-UX, and Linux.  The server to which I'm trying to connect is controlled by the IT department of Nashville Metropolitan Government.  I have gotten into server management and can see that the SSH server is runnung but when I try to make the connection with AccuTerm, I get an AccuTerm error that "No supported SSH2 signature scheme exists".  When I click on the details it tells me that AccuTerm supports ssh-dss and ssh-rsa.  I know lots of you are using AccuTerm on Windows servers, can anybody suggest what I am lacking.  I suspect there is something on the server that I need to enable or set up.  As I said, I have limited knowledge on Windows servers; or is there something I need to enable on the AccuTerm? Dale------------------------------Dale KelleyI'm it!Dale W Kelley IncHohenwald TN US------------------------------

MVIS 1.3 supports oAuth, allowing developers to easily integrate their created APIs with third-party authentication providers such as Auth0 and Okta and provide token-based authorization, ensuring seamless integration with enterprise application security configurations. This first video provides a detailed overview of the capability and how to use it. This video is a demo of the application. I'm happy to answer any questions you have below!------------------------------Amey RokdeSenior Software EngineerRocket Software------------------------------

Christian, Apparently, the extension in Stack Overflow is no longer available.But thanks for the information so I can stop spinning my wheels! Dan------------------------------dan brombergRocket Forum Shared Account------------------------------

Since the update to MVBasic  2.7.1 when using the online edit mode whenever I go to open a program, I get the following error message:asjava.uniobjects.UniSubroutineException: The RPC failedI can navigate around the server and look at the files and switch accounts with no issue. The moment I go to open a program it seems to disconnect me.I attached the log for extra information.As a work around I reverted back to 2.7.0 and everything works as intended.------------------------------Jeremy BartonRocket Forum Shared Account------------------------------

Hi everyone, I'm very new to Host Access and D3. We're currently working in a D3 Pick environment using the TCL (Terminal Command Language) prompt, and I need to learn everything from scratch. I do have access to Rocket Software's D3 reference manuals, but they're quite large and a bit overwhelming to read cover to cover. Could anyone please suggest the best places to find learning materials - especially video tutorials that cover basic concepts, TCL commands, creating simple programs, and understanding how everything works with real examples? I really prefer videos or more practical, hands-on resources rather than just manuals. Thanks so much in advance for your help!------------------------------Rima PrajapatiSenior IT SupportRocket Software Forum Member------------------------------

Is it possible to call a web page / open a new browser window when running AccutermIO?  If so, is there documentation available?------------------------------David KylesDirector of ITMDC Interior SolutionsGlendale Heights IL US------------------------------

Hi, I've been trying for a few weeks to get MVVS to work with Online Editing. I'm able to log on to my server and see all the different accounts and their files; however, when I try to open up a program, I get an error message saying the file could not be found. Further inspection into the logs revealed that there is an error with XToolSub. The error is U2 XToolSub logon account exception, {oldAccount: TESTACCOUNT, newAccount: XDEMO com.rs.mv.mvvs.common.exception.MvVsException: failed to logto account Is there something that UV admin has to do to allow for the logto to succeed? Any help would be appreciated.