MultiValue Tools

I'm trying to work out the correct syntax for the "select" option to "limit the returned results" when testing in Swagger using a UniVerse database as the data source. For example, I have a date field and want to select all the dates in a specific year. Is there some documentation that details how this works? I've tried standard UniVerse syntax, standard SQL syntax, but neither of these seem to do what I want to do.

AccuTerm version 8.1.0.0 has been released on June 30 2023 for the below platforms/versions:Windows       Windows 10,  Windows 11,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

I'm pleased to announce the release of AccuTerm 8.1.0.0 This is the first GA release of AccuTerm as part of Rocket. Most importantly, the product now follows a unified Go To Market for the multiple components of AccuTerm. AccuTerm Desktop and AccuTerm.IO (or AccuTerm web) are now released together as one product with the same version numbering.  There are numerous defect fixes and enhancements that will continue to bring the product forward. Some of the key highlights are: AccuTerm web support for on-premises deployment. This will allow customers to deploy the browser based AccuTer

My application seems to be blocking the ssh connection from Visual Studio Code to my Linux server. With other Rocket products the user is identified as terminal, phantom, uvnet, etc. Is there a special type for the login from MVVS?

Somewhere along the line, we have lost the setting in SB client where if you highlight and copy some text on the screen, then paste it into something (like NotePad++ or an email), it loses the CR/LFs.  This means, instead of retaining the format from the screen, the pasted result is one big string on a single line. Where is the setting to tell SB client to keep the CR (CR/LF) when you copy data from the screen? Thanks JRI

Hi All! We have a application (SEMtek developed by Entrinsik) utilizing Universe 11.3 and SB 5.5, with the client being SBC 5.5 (currently).  We've gone through multiple upgrades, however I believe our limit has been reached for UV and SB+ due to some programing limitation in the produce that are no longer being developed.  We've had this running for 15+ years, so all iterations of the supporting software along the line. We're using SBClient uding the GUI for SB.  We've had no issues with SBC up until newer versions of Windows 10 and similar time frame Server OSs.  In Server 2016, all items the app uses in SBC seem to work fine.  In newer releases of Windows 10 and Server 2019, SBC the main interfaces seem to work fine, but some sub menu items completely crashes and closes out the app without error.  I have ticket in with our VAR Entrinsik and will be digging myself to see if I can find what processes this death clicks are using.  Just thought I'd post here to see if s

hi rocket, thank you for the functionnality.  Really important when we perform remote maintenance... no need to sync all the system. So, here is my first return of experience. 1/ why userid/passwd in clear into json ?  Please, use vscode-api#SecretStorage (same comment about offline editing/connected)  2/ after Connect, the list of UVAccount is not sorted / filtered : can you add a property 'selectOptions' in the server objet configuration then you execute 'SELECT UV.ACCOUNT ' + selectOptions and we can set it like 'WITH @ID LIKE "blabla" BY dictname ... etc 2.1/ add a property ''account.included[]' to the servers settings 3/ when we drill down into an account, rmv.Explorer lists (not clear) ?? all ? Type1 ? ... so can you add into servers settings 'files.included[]' ? 4/ when we drill down into a source directory rmv.Explorer list all source files.  so can you add the same filtering like in the  'Group view'  5/ can we h

Hello fellow PICKIES, I am trying to use FTD from Accuterm to run a file download. I need to select and sort the items it is going to list into an excel spreadsheet. I can get this to work through the wizard, but not by passing in the data statements in a program.  Help? This works: 05 ED VOC K66Top of "K66" in "VOC", 63 lines, 983 characters.*--: p001: [Job]002: FileName=mvdb://MultiValue Host*$52370\\*\\K66003: TransferProtocol=Kermit004: TransferMode=Text005: PreserveExtension=Yes006: HeaderRow=1007: Delimiter=Tab008: Direction=Download009:010: [UL]011: TransferType=File012: HostFile=013: SelectOption=SelectAll014: SelectString=015: Database=Excel016: HostItemIds=017: DosPath=018: DosFiles=019: WorkbookName=020: Worksheet=021: Range=022: AccessMDBName=023: AccessTableName=*--: p024: A

I am new to accuterm, about a year now, and am still struggling with trying to understand the pieces I need in place to have a graphical accuterm screen display on the internet. I've been told repeatedly that its possible and functioning with my release of accuterm8. Can anyone share with me even a static screen accuterm display on the web? Even just a box that says 'You are here.'There are obviously pieces I need for the web address to access my accuterm display but I don't even know what questions to ask....Anyone?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

We're pleased to announce the release of the Rocket® MV BASIC for Visual Studio Code (MVVS) v2.1.0 with a preview of the new Online Editing feature! Rocket MV BASIC for VS Code (MVVS) offers features to help your developers modernize, simplify, and work more productively in one of the most popular development environments, Microsoft Visual Studio Code (VS Code).

Enrique, if you do a demo of your web system I would ask to be included.DaleSoftware contractor in middle Tennessee

  Respecting a rule of this forum about not posting product promotions, I moved the content of this thread as a reply to Katlheen's question  https://community.rocketsoftware.com/discussion/can-anyone-help-me-visualize-a-web-page-using-accuterm ------------------------------Enrique Ignacio MurphySoftware EngineerAleator SRLArgentina------------------------------

In AE and AccuTerm, if I use a '!' to start a comment, the editor ignores that line, leaving where I put it as the author but it does align the '*' comments based on the options set. In the MVVS editor, the "indent.commentLine" option seems to be treating both '!' and '*' comments the same. If it's set to 'true' the comment gets indented the same as the previous line. If it's set to 'false', the comment line(s) are returned to the left margin. Is there a way with the current settings available to retain the capability of '! comments remaining in the position determined by the developer? Below are examples: indent.commentLine set to true, before Format with Rocket MV BASIC       EQUATE CUSTOMER.SUFFIX TO 5       * !******** ! This is the end !******** indent.commentLine set to 'true', after Format with Rocket MV BASIC  

Hi,I'm trying to use U2 Web Designer to create RBO's. The accounts are on an AIX server. I can successfully attach to the host and see the accounts. I can also successfully enable accounts for WebDE. It's when I click on "U2 Web DE Elements" and I'm asked for a password it always comes back with an "Access is denied error" I've tried the rbadmin/redback combination (This works elsewhere as I can log on to the admin server with it) and several OS users but nothing seems to work. I first tried this several months ago and gave up out of sheer frustration but now I really need to have a look at this.Everything else is working well. I also found that I had to modify permissions on the $UVHOME/UV.ACCOUNT file to create a new account through designer. Perhaps I need some correct permissions set somewhere else.Any ideas as to what I'm doing wrong? What other options for a valid username and password are there?Designer version 5.3.0, build 3425

If you are a current user of Rocket wIntegrate, I'm interested in hearing from you. What version are you on? What do you like or dislike about it? Are there any enhancements, features or improvements you'd like to see that would make wIntegrate an even better MultiValue tool for you? In case you are using an older version and missed the announcements earlier in the year, we were proud to announce the release of wIntegrate 6.4.4? To learn more, read the wIntegrate 6.4.4 release announcement to find out how to update to the latest version. Already a 6.4.4 user? What feature have you come to appreciate most?  ------------------------------Hernando BordaRocket Software------------------------------

Will this be fixed in a future version?------------------------------Jan Van SchalkwykSenior Analyst DeveloperHeritage BankToowoomba QLD Australia------------------------------

I am currently using VSCode using the Remote SSH tools and modifying code on the server. The repository on the Linux server is actually configured as a git instance.It's my understanding, using the MVVS extension, the git repository is on the user's PC or shared drive (OneDrive) but the files on the Linux server are not actually a git repository. The net result of this is that the version of a program on the server is always the latest saved version, regardless of branch.It appears that this SFTP extension works well for keeping items in the local repository uploaded to the server. Any other suggestions?This could actually simplify life to some extent. The cautionary tale is that if someone modifies an item on the server side, it must be manually pulled back to the user's repository. Or, is there an "automagic" means of doing that? Also, any items ID's may need to b

Our program uses a pre-compile routine which modifies the code before running the BASIC command to create the object code. Since Rocket MVVS appears to call the BASIC command when compiling, I'm wondering if there might be a way to call our pre-compile routine instead of BASIC.We're in the process of adopting Git and this would help us take full advantage of Rocket MVVS.Thanks in advance for any ideas.

At the risk of being told "You should not do that!", I'm working with a 35 year old code base that has been on Pick, AIX and Linux over the years. So, folks decided to used characters like asterisks ("*") and question marks ("?") in item ID's as delimiters. When archiving these items and moving them from Linux to Windows, I have functions for converting the ID's to URL's and back. However, these items will not move cleanly from the Linux folders to Windows folders. So, the question at hand is whether there's a good option for converting those item ID's in flight. Unfortunately, there are too many places where those ID's are embedded in code to go down the path of fixing them all, even though that might be preferable. An aside, WinSCP has implemented nice functionality that makes these conversions when moving from Linux to Windows and back...------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX----------------

I feel like I must be missing this but have been unable to find it in the documentation.   Is there a way to set the focus to a particular grid cell in code?   I have a grid with a selection box.  If the user selects a given row I would like to take them immediately to the text box in column X on that row for input.  Thanks.

We're pleased to announce the availability of the Rocket® MV BASIC for Visual Studio Code (VS Code) v1.10.1 maintenance release. Rocket MV BASIC for VS Code (MVVS) offers features to help your developers modernize, simplify, and work more productively in one of the most popular development environments, Microsoft Visual Studio Code. Starting with Rocket MVVS v1.7.0, a Minimum Viable Product (MVP) release, we shared a debugging preview with you and since then we've made several quarte

Just tried accuterm on a windows 11 machine and  it was working fine until an Accuterm GUI program is launched, then it opens the GUI form and freezes. Anyone run into this andor have a solution?

We are running 2 versions of U2WebDE (AKA Redback) 4.4.3 5.3.0 on our Linux box.  Both versions have 3 environments that connect to our UniData accounts: DEV - used by programmers (me) to write new stuff PILOT - used by super-users to test changes prior to loading to LIVE LIVE - available to anyone who can access the web pages   We have been smoothly running this way from over a year with the plan to phase out the old version (4.4.3) by the end of the year.Yesterday, a web page in our PILOT (user testing) environment started to fail - hard!  The lines of the web page making the call are as follows: accnt = Application("ERPAccount") userid = Application("Ruser") passwd = Application("Rpass") set oOrder=CreateObject("RedBack.RedObject") oOrder.Open2 accnt,"SF:oOrder",userid,passwd The oOrder.Open2 is failing hard enough that I have to rebo

I am being asked to break a tab delimited file as part of an assessment. How do I identify the tab delimiter?------------------------------Kimberly CrumRocket Forum Shared Account------------------------------

we mainly use mvis with a subroutine, see definition below.  currently, if the input JSON has the wrong input data element we return a JSON array with error string. however, when use this the HTTP return code is always 200. this means other systems have to look for error strings in response. is there a way to raise the HTTP error code to something else other than 200  to something like an error code of 400 to indicate an error occurred?