Rocket MultiValue

We have a need to create a single URL RESTful service that will give a different response for GET and POST queries. For GET, the service just echoes the data passed, but for POST it must return data from the database in JSON format. I created an "endpoints.yaml" to create the GET, but have not found any way to create a single URL that answers both GET and POST and treats them differently. So we might have, for example, a call to the URL: http://testapi.mbs.net.au:7171/APP/subroutine/TESTSUB?responsecode This would be expected to simply return the string "responsecode" as specified in the URL. However, if data is POSTed to the same URL (minus the "?responsecode" part), then JSON containing database information would be returned. I've tried various things in endpoints.yaml but have had no success. Can the above be accomplished in MVIS and, if "yes", how would we go about doing it?------------------------------Martin ShieldsSenior Technical ConsultantMeier Business Systems PTY LTDCarnegie

Hello , I have been installing and checking MVVS for a few days now and I have a questions , problems :   - GO TO DEFINITION function - always returns "No definition found for '' " - GO TO REFERENCES function - always returns "No references found for '' ".   do i need to set something?? Displayed functions:

Hi, I am trying to build a JSON object using UDO functions. How do I format numeric values to display 2 decimal values, by default the output is either an integer or 6 decimals. Below is a snippet of test code and the output generated:          name = "capitalBalance"      value = 672.500      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "amountAvailable"      value = "617.00"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "arrears"      value = 77617.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "advance"      value = 0.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT        name = "interestAccrued"      value = 0.27      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "installmentDue"      value = "15437.01"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            GOSUB TEST_AND_DISPLAY_OBJ      RETURN BUILD_JSON_OBJECT:      ST = UDOSetProperty(OBJNAME, name,

we are working on D3 to QM conversion.  The client had a number of select statements that use wildcards. we already know, and are converting to "pattern matching" from QM. The square brackets all still work.  Is there any characters to use similar to D3      with part.nbr = "A^^3^^" The up carrot was a wild card character for a single character. I have been searching the online docs, but have not found it. (like most docs, if you know what you are searching for, it is easy)------------------------------Jesse TilliaRocket Forum Shared Account------------------------------

in my phantom log  I saw the msg  cp: failed to close (specific file name), I looked at the file checked permissions and  everything looked good. In the program it processed all of the previous files with no errors. the last for file showed these errors. the programs are running on 15 different server and none of the other servers have this issue. comments? help? Thanks, Theo

Another frustrating problem I need some help with.  Added a new laser printer, wired ethernet connection. jBase 5.8.5 on Windows 10 Multi-page program output now prints 60 lines on page 1 , 4 lines on page 2, 60 lines on page 3 and so on.  There is no way to set a default line/page on the printer.  I've tried using TERM to change the printer length to 56  and tried creating a formtype with the shortened length but neither worked.  How do I "override" or work around the misplaced formfeed?? Thanks, Marc------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ US------------------------------

Hi All -  I just found on our system that exiting a program does not clear an active select list. Im unsure if this is universe specific as I did not have to clear select buffers in Unidata, but this has shown to be an issue here. There is a basic CLEARSELECT statement just as there is at TCL. Is that a standard for anyone running Universe? To use CLEARSELECT in your programs? Do you use it generically when entering or exiting a program?  And now that I've seen this - what other pieces should I be on the lookout for that are saved between programs by user? Obviously named commons and passed variables but...any like this savedlist that might not be obvious? Lastly, is there an alternative to changing the code? Like an option I could set at tcl or in code that clears the buffers when exiting a program? Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

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 AccuTerm on their own hardware without depending on the hosted version of AccuTerm.IO. SSO support. AccuTerm can now be configured to use single sign-on and rely on the Windows user credentials to authenticate with an MV application server. Improved GUI for AccuTerm web. This release contains multiple enhancements to bring the GUI on a browser to parity with the AccuTerm desktop version. Security Certification. 8.1

All, I use chatGPT+. I asked it to write a multivalue basic program to calculate a loan payment. This is the result. 0001: PROGRAM LoanPayment0002: PRINT "Enter the loan amount: ";0003: INPUT LoanAmount0004: PRINT "Enter the annual interest rate (as a percentage): ";0005: INPUT AnnualInterestRate0006: PRINT "Enter the loan term in years: ";0007: INPUT LoanTerm0008:0009: MonthlyInterestRate = (AnnualInterestRate / 100) / 120010: NumberOfPayments = LoanTerm * 120011:0012: IF MonthlyInterestRate = 0 THEN0013:    MonthlyPayment = LoanAmount / NumberOfPayments0014: ELSE0015:    MonthlyPayment = LoanAmount * MonthlyInterestRate * (1 + MonthlyInterestRate) ^ NumberOfPayments / ((1 + MonthlyInterestRate) ^ NumberOfPayments - 1)0016: END0017:0018: PRINT "Monthly payment: ", MonthlyPayment 'R2'0019: END It took a bit of cajoling but within three corrections this was the end result. Does anyone have a BNF or ANTLR definition of the BASIC language? I'd like to feed it into chatGPT and see how it i

Intermittently, we are getting the following error message when updating large files.  The files check out OK in jBase and using chkdsk.    Running 5.8.5 on Windows.  Application programs have not been changed in years. Dynamic files READ error number 2007 at position xx:xxxx, File '\\xxx', item id 'xxx' Error 2007 during READ_ERROR to file xxx Enter I to Ignore.... When this happens, I do a 'select' of only the records that reference that particular item.id and re-run the program.  The item will then update properly!  Short term, is there a way to capture the error messages and bypass the prompt so as not to have to interrupt the operation and allow the program to run to completion?  Any diagnostic help would be appreciated. Marc------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ US------------------------------

hello,  when we define a function like  def funcname(a,b,c); return (a * b + c) Can we use keyword argument syntax when calling a method/function ?  like PyCallFunction("module","funcname",a=1,c=2,b=3)   or is it mandatory to use positional argument ? PyCallFunction("module","funcname",1, 3, 2) ?  many thanks------------------------------Manu Fernandes------------------------------

    Key Takeaways:Do not use dimensioned redimensionable-array elements for EXECUTE variable targets for CAPTURING, RTNLIST and SETTING and variable sources for PASSLIST.The areas of concern:1. Information style redimensionable arrays may change size in the executed program.2. Arrays of either flavor compute to a temporary in a PASSLIST that gets overwritten by constructing the command string in a concatenation. This UniVerse bug results in the command string passed to the command as the select list.  Environment:UniVerse 11.3.1.6022Fedora Linux UniVerse supports two kinds of array.  Pick sytle arrays have fixed dimensions at compile time. Each element of the array takes one VARTAB (variable table) slot. VARTAB uses an unsigned short for an index which limits the total number of slots in a compilation unit, program or subroutine, to 64K elements. (This limits an array to a maximum of 64K elements.) Information style arrays specify dimensions at run time and may change and consumes only

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?

I get a lot of survey's everyday. I have received several from Rocket Software on what I would like to see as Enhancements to UniVerse in particular, but multivalue in general. I thought I would toss this our for discussion with the forum members. Any thoughts?Multivalue Enhancements Better overall performance Multithread using data reader/data writer Compile into IL that can be optimized on a given architecture (ECMA 335) Improve connection to alternate database types SQL No-SQL OS Independent OpenQM data type validation, better data cleansing Improve database mirroring Improve Transaction processing Improve Publisher/Subscriber performance Better use of improved system resources Configuration Expert System, Machine Learning Better development environment Visual Code with ability to work on remote servers and multiple accounts VC graphical compiling, cataloging and debugging Extensible Terminal emulator Lint type program to identify problems and poor programming practice

I have a Python script that uploads a program and tries to compile it. But every time it compile my program errors because we use Pick.  Can we set up some options so the command executes using Pick flavor?  I already tried setting the TCLTYPE before running the command, but it doesn't work. Connection establisheddone readingfile uploaded Compiling Unibasic: TESTPROGRAM in mode 'u'.main program: syntax error at or before<line 2578>       READSELECT NH ELSE HN.RECS = ""            -----------------------^Expecting: =,:,+,-,*,/,[,< Any suggestions?  Thanks in advance

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

Last year, having switched back from Unidata to Universe, you all helped me with simple triggers - which on universe are made as file indexes. Now I am trying to apply that to a NEXT.ID but it's stored in a DICT, not uncommon for PICK. Trying to make an index on a dict, however, didn't work. >CREATE.INDEX DICT KHTEST TRIGGER   Only records of type A, D, I or S allowed! I know this trigger works as I had applied it to the data portion originally. Ideas, suggestions, thoughts? Thanks------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

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 someone has any ob

Is there an environment variable or some config setting in jBASE that will prevent a programmer from attempting to write a record with a null record key?  I would prefer this work globally and not based on a particular file.  This system has a lot of very old code that has probably gone through several conversion prior to jBASE.   I am aware I could put a trigger on the file, but I'm finding this issue across multiple files and would like to resolve it quickly.   We're currently running jBASE 5.7 but will soon be upgrading to 5.8.  Thanks. ------------------------------J EdwardsIT ManagerPlimpton & Hills------------------------------

Hello to all !!!!  THere is always a first time ..... what the heck is this ???  RESIZE: FL_GRPRESIZ bit was set on group 0.  Not resizing file. Thanks to all in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

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 have a local backup   of the file we edit , into the directory whi

I am learning how index work in OpenQM.  But, my program is aborting when I try to address the "list.var" SELECTINDEXV index.name {, value} FROM file.var TO list.var Here is my test program: PROGRAM TEST.SELECTINDEXV  OPEN "MEMBERS" TO MF ELSE CRT "CANNOT OPEN MEMBERS"; STOP  SELECTINDEXV 6,"999-999-9999" FROM MF TO MEMBER.ID  CRT MEMBER.ID  IF MEMBER.ID="" THEN    CRT "NO VALUE"  ENDEND Here my results with the abort.  MEMBER.ID is the correct ID. :RUN BP TEST-INDEX20050000000121: Value not found where required at line 5 of /usr/qmsys/TEST/BP.OUT/TEST-INDEX2: ------------------------------Tedmund HurlbutSelf RegisteredSimpsonville SC US------------------------------

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: AccessConnectString=025: TextFileName=026: IncludeAllAttributes=False027: Attributes=028: AutoID=False029: SuppressItemID=False030: FirstRowHasColNames=False031: SelectByName=False032: AutoIDPrefix=033