Rocket MultiValue

Hi everyone,  Just a quick reminder: starting tomorrow, Rocket Forum will be temporarily locked as we roll out an exciting transformation. We can't wait to welcome you back to a refreshed, more intuitive, and inspiring community experience on October 23rd. Here's what to expect: The Forum will switch to read-only mode from October 15th to October 23rd. You'll still be able to browse existing content, but posting, commenting, and liking will be paused during this time. After the improvement work wraps up on October 23rd, you'll gain access to the new, improved Rocket Forum, featuring simpler navigation, exclusive insights, and even more recognition for your participation. Important: Upon your first log in after October 23rd, you'll be prompted to reset your password. For more information about the changes ahead, please visit this page. If you have any questions, feel free to reach us at community@rocketsoftware.com. Thank you for being a vital part of our community on Rocket Forum.

Hi All, Hopefully this is a quick one, that I did not want to trouble Rocket support with. I know that UV11.3.5 is certified for Windows Server 2019, we aim to get as many of our customers on Windows onto Server 2022. However, we may have some who want to stay on 2019. To your collective knowledge are there any issues in sticking with 2019 for UV11.3.5? Many thanks.

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]------------------------------

Hi Running uv 14.1.1 on Windows, we are waiting to receive the patch 1002 Hotfix. Meanwhile, how can we restart uvcleanupd.exe without restarting uv himself !  If I start it from a console, it works but not as a background process. Thanks for any sugg.  Manu

Greetings All,  I am running into an issue when using Accuterm. I just switched my internet provider to Startlink.  Startlink for home use does not have a dedicated IP address so I am using a GL.Inet GL-SFT1200 router that I have a  wireguard tunnel running on the router. I also I can log in direct from my PC using Surfshark with a -dedicated IP with no issues when connecting. When using wireguard I am able to connect but get an error message - "WED requires AccuTerm 2000 or later to run!  "  I am also trying to print to port 9100 to the wireguard but have not gotten far on this.  Am I missing something in the set up?  Thank you in advance. 

Do we have a version of U2 Toolkit for .NET Developer with U2.Data.Client that supports any .NET 6 or preferably .NET 8 applications? I'm struggling to find information on it.

Is there any ETA on when MVSP for Linux - specifically .NET is going to be available? Thanks! g.------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

I understand that UV14.1 has a compatibility setting in uvconfig which allows it to support versions of SB+ before SB+6.5.0. Has anyone used this functionality and more specifically with SB+5.5/SB+5.4? If so, are there any things to be aware of? Thanks in advance

This is for a UNIVERSE environment. I've tried setting the account to use in servers.mvbasic.json, as it is using XDEMO by default at the moment which causes the authentication process to fail. I need to manually specify which account is used. Looking at the logs, it appears this is passed in during the "connect U2 start" stage as accountName, but both this and account seem to have no impact. Is this controllable? 

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]------------------------------

We have an app that is using the U2.Data.Client (version 2.2.2) to call a subroutine and the app is using transactions for an orchestrated business flow. Part of this orchestration is calling a subroutine and I need to know if that subroutine is, or has a way to, operate within the transaction of the U2.Data.Client. If so, how would I get that to work?

Hey folks, Sorry for the continued PROC questions but the owner of our company loves them...groan! Question for y'all, is there anyway to create a unique list ID within PROC. like "SAVE-LIST LIST.NAME.PORT#" or ...? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Does anyone know of a quick way to print from OpenQM (Windows) on a HP OfficeJet Pro 9120e Series printer?------------------------------Jack YatesCIO/ConsultantUnited Refining CompanyWarren PA US------------------------------

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------------------------------

HelloI am testing the new-ish 'DT' conversion code in UV 11.3.5 (on RHEL8) and am having no success getting it to do what seems like simple conversions. I put together the following test code to give it a go: -- * Testing the new DT conversion code sys.VAL     = system(99)now.VAL     = now()local.VAL   = datetimel()utc.VAL     = datetimez() crt "NLS status : ":oconv(system(100),"S;'On';'Off'")crt "system(99) : ":sys.VALcrt "now()      : ":now.VALcrt "local      : ":local.VALcrt "utc        : ":utc.VAL lst.TESTS = ''lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "dt"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "DTIS"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "dtis"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1

For those wanting to learn MVIS, I have created two (free) step by step guides to creating an MVIS/REST backed website. The first of these uses Vue 3, which is arguably (well I will argue) the most friendly of the client side typescript style of web frameworks, and the second uses Microsoft's .NET Blazor so you can take your pick. The guides will work with the U2 Trial Editions and the software is free. Some knowledge of TypeScript or C# would be useful but you can probably follow on without it. I've posted these on the new Rocket Innovations section, or you can download them from the Free Training section of my website (www.brianleach.co.uk). Have fun and good luck!------------------------------Brian LeachDirectorBrian Leach ConsultingChipping Norton GB------------------------------

A couple of posts outlining how I go about importing and exporting things, I use /etc/passwd as the example as I needed a script to move some users over. I have a bash script to do this but moving more of my workflow into Pick is my goal.  Importing into Pick: https://krowemoh.com/devlog/importing-linux-files-into-pick-.html Exporting out of Pick: https://krowemoh.com/devlog/exporting-pick-records-to-linux.html ------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Hello all - we are switching from one box (unix) to another (linux). We have some programs that check server IP, hostname, uname - to know if the user is addressing our test or production environments. Our question is does anyone know of a Unidata environment variable that holds this type of information we could query easily? Thanks for any ideas! Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

A couple of posts outlining how I go about importing and exporting things, I use /etc/passwd as the example as I needed a script to move some users over. I have a bash script to do this but moving more of my workflow into Pick is my goal.  Importing into Pick: https://krowemoh.com/devlog/importing-linux-files-into-pick-.html Exporting out of Pick: https://krowemoh.com/devlog/exporting-pick-records-to-linux.html ------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Greetings all! Attempting to: Create a list in PROC Call a catalogued Basic program Using PROCREAD in that Basic program in a LOOP/REPEAT construct Expecting the PROCREAD would pop off list elements until exiting the LOOP/REPEAT construct. To date, I haven't been able to get any data passed.  Does anyone have the mojo to get this bugger working? THX in advance for y'alls always great advice! ~Doc

Hi Guys, So we're migrating to D3 we have had initial success following the online documentation but just wondering if anyone else out there has done the same and has any tip or advise for a smooth transition. Thanks in advance Steve------------------------------Steven ReidDeveloperSandiford Solutions LtdManchester GB------------------------------

hi everybody, I search a solution to read the locks info when I'm in a transaction ! I need it to act correctly on LOCKED clause..  OPEN 'MD' TO F ELSE STOP TRANSACTION START THEN CRT 'TR OK' READU R FROM F,'EFV' ELSE R = '' EXECUTE 'LIST.READU' EXECUTE 'PHANTOM LIST.READU' EXECUTE 'SH /C smat -r' EXECUTE 'ANALYZE.SHM -r' TRANSACTION ABORT RELEASE F,'EFV' the runtime says :  12 RUN EFVPROGS TESTTRANS TR OK Verb "LIST.READU" illegal when a transaction is active. Verb "PHANTOM" illegal when a transaction is active. Verb "SH" illegal when a transaction is active. Verb "ANALYZE.SHM" illegal when a transaction is active. Is there a hidden SYSTEM(?) to retrieve the LIIT.READU / list_readu / smat -r output ?  (I can perform all READU before TRANSACTION START and if LOCKED perform what I need but I'm into a generic subr

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------------------------------

The latest PE version is 8.3.2 I believe, is it possible to get a PE version of 8.2.4 if not I can work with 8.3.2 just asking as the version we are using in production is 8.2.4  and I would like to stay with our production version but if not that ok, just asking. thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------