Rocket MultiValue

We're pleased to announce the availability of Rocket® MV BASIC for Visual Studio Code (VS Code) v1.1.2 Rocket MV BASIC for VS Code offers features to help your developers modernize, simplify, and work more productively. We are developing and releasing MV BASIC for VS Code (MVVS) at regular intervals to provide more frequent enhancements and fixes. Version 1.1.2 includes editing feature enhancements: Code Lens (New) allows you to review your code and find references to variables, functions, or subroutines without leaving the editor. Signature Help has been enhanced to automatically update the parameter lists of user-defined functions when editing the BASIC files that contain those functions. Other Enhancements: Three new statements have been added to Code Folding to further improve code readability for large blocks of code: WHILE and UNTIL clauses in loops as well as the LOCK statement.  The large code block surrounded by these statements can be folded into one line so that users c

Hello,I wonder how UNIBASIC manages memory allocated by python modules executed via pyCall which returns PYOBJECT. And especially if the memory is correctly restored at the exit of the programs and subroutines which instantiated these variables.Is anyone who knows ?------------------------------Manu Fernandes------------------------------

Has anyone successfully been able to transfer binary files from server to client through SBClient (UniData)?It appeared to be possible to do a PD.LO using B and/or X options, and I tried also via UniBasic with OSREAD, but it does not work.  I opened a recent Rocket support case on this and the official answer was, despite some initial success from Rocket's side, ultimately it isn't supported (SBXA-18778).  Despite that news, I'm interested if anyone here has managed to get it working with (any version of) SBClient with some combination of luck and skill?  I have heard rumors it is possible if the file is uploaded through the client to the server in the first place, but that is not the case here.  The use case is, small Excel files are generated for reporting on the server.  The users would like to download these to their desktops.  I could arrange alternate delivery, but they prefer saving on their PC.  They are used to downloading .CSV files, which are text and transfer through SBClie

I have been testing D3 V10.3.2 on a test server before moving on from D3 V9.2.2.All programs must be recompiled when moving to the new version. I have found an issue with the BASIC EXECUTE statement whereby programs using the old style of ,//IN.< would not compile, bombing out with an error instead. Changing the code to the new(ish) style fixed the problem. I have notified Rocket of the issue via our support provider and hopefully, there'll be a fix in D3 V10.3.4.------------------------------Walter KiessManager ITPolice Superannuation BoardAdelaide SA Australia------------------------------

Hi ,Using in-basic python I interface function like var=pyCallFuntion(module,function)  how can I define if the var is a uniBASIC Var or a PYOBJECT ? Then, is there a methods from UNI BASIC to perform python str(var). Any help is welcome.------------------------------Manu Fernandes------------------------------

what is the best strategy to backup universe database?we plan to use uvbackup tool. Will this impact performance?------------------------------Abdus ThommilTech ArchitectFlextronics International Management Services LtdSan Jose CA United States------------------------------

I'll claim a senior moment here... An associate is trying to write an I-type dictionary that retrieves the first subvalue in a set of  fields. I can certainly do it with a subroutine and the FIELD function, but the FIELDS function specifically excludes use of the value mark or sub-value mark as delimiters. Suggestons? I'm sure it will be a forehead slapper when presented...The existing data is:ABC@SVMDEF@VMGHI@SVMZBA@VMQARHe wants it to return:ABC@VMGHI@VMQARThanks, in advance!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.We would like to know how anyone else is doing this.------------------------------Graham FallwellOwnerSoftware Applications Ltd------------------------------

When viewing an U2 BASIC program within VS code, Universe Basic @ variables such as @WHO are underlined with '~' characters.  According to VS code, these variables are undefined​​​.  I would have expected these not to show as undefined.  Can this be corrected?------------------------------Steve GleasonSenior Programmer AnalystGuitar Center------------------------------

We have recently developed the code lens feature in vs code extension and would like to share it to you.This feature works for all basic definition statements, including: variable declarations, function declarations, equate declarations and label declarations. It also displays the number of references on these statements. Clicking on the value of a reference will display the specific reference information. See the following example for details. Also, if you want the feature to prompt other information, or if you have other ideas or comments, please share with us.Thanks!------------------------------Jingwen LiRocket------------------------------

Hi All, Recently we are investigating that how to implement BASIC compilation in VS Code extension. I want to share our ideas, and we are very appreciate if you can provide suggestions and ideas. (The following content is just our initial ideas and design prototypes.) The main use of compilation is to find out the errors or warnings after code change. User can choose to sync the source code to U2 server or not. If yes, source code and objective code on sever would be overwritten after compilation. Before using compilation, user needs connect to a U2 server. And we will provide 2 methods to compile BASIC programs. 1. Compile BASIC programs through VS Code task. User can run VS Code default build task to start compilation. We can provide a target files list in the task configuration file, so that multiple BASIC program files in current account folder could be built together. 2. Compile modified BASIC programs.User can right click a file in the editor to display context menu and select "

Hi All, Recently we are investigating that how to implement BASIC compilation in VS Code extension. I want to share our ideas, and we are very appreciate if you can provide suggestions and ideas. (The following content is just our initial ideas and design prototypes.) The main use of compilation is to find out the errors or warnings after code change. User can choose to sync the source code to U2 server or not. If yes, source code and objective code on sever would be overwritten after compilation. Before using compilation, user needs connect to a U2 server. And we will provide 2 methods to compile BASIC programs. 1. Compile BASIC programs through VS Code task. User can run VS Code default build task to start compilation. We can provide a target files list in the task configuration file, so that multiple BASIC program files in current account folder could be built together. 2. Compile modified BASIC programs.User can right click a file in the editor to display context menu and select "

I've been struggling with this for some time now (years, that is): The precision of calculations performed in D3.As everyone knows, D3 performs calculations to a default of 4 decimal places. It then truncates the result so everything past the 4th decimal place is removed. This in itself is a cause of concern as it introduces the 1st of several calculation inaccuracies. From my understanding, this occurs for every calculation performed, whether it's in a single expression or in separate statements. Thus there may be several inaccuracies in a single expression, particularly when fractions or division is involved.To get around this, I have arranged my expressions such that division is always performed last (where possible). But this doesn't solve the problem completely though. There is always an intrinsic error in the calculation/expression due to the truncation as the expression is not calculated as a floating-point expression. When you're dealing with hundreds of thousands or even milli

While PickBASIC object code ( pseudocode, not flash object ) is forward-compatible ( later D3 versions ) without recompilation, it is not completely backward-compatible ( earlier D3 versions ) because of op codes that have been added in later versions of D3. Example: Code compiled on 10.2 will run on 10.3, but code compiled on 10.3 may not run on 10.2.I didn't know this until just a couple of days ago. For years I've helped people upgrade D3 versions knowing that they don't need to recompile their source, especially when the source has been stripped and only object code deployed. Turns out I never helped anyone go the other way with stripped source. This came to my attention when a friend of mine in the UK upgraded his dev box to 10.3.3 and tried his normal deployment mechanism to a 10.2 box. Blew sky high.  This had never happened to him before.Turns out that 10.3 contains a LOT of op code changes to facilitate the mvBase to D3 upgrade plan as well as some other optimization for perfo

I have several servers with UV 11.3.1.6022 installed and, on one, I'm getting a very odd behavior on selects. This is only happening on our development server, but it's in multiple accounts and the configuration is the same as other servers.If I create a list with only one item in it and then do a "GET-LIST list_name". The system shows zero records selected and will not list the item. It behaves the same if I'm using &SAVEDLISTS& or another file for storing the lists. >CT MLISTS WNB710_20180101.WBP_TEST       WNB710_20180101.WBP_TEST 0001 TEST.FNCODESGET >GET-LIST MLISTS WNB710_20180101.WBP_TEST Zero records SELECTed.  SELECT list number 0 cleared. If I create a list with multiple items and then do a "GET-LIST list_name", the selected count will consistently show one less item than is in the list. However, if I do the "GET-LIST" and then list the file for the items, all are shown... >CT MLISTS WNB710_20180101.BLBP       WNB710_20180101.BLBP 0001 FNCODESGET 0002 FNCODES

@Leon Pearce and @Kathleene HunterJust to clear something up here on the question on the SAVEDLIST length question thread. The SAVEDLISTS error with a '*' will only happen on UniData on Windows, in fact there are several characters that Windows forbids in file names so it's not just a '*'. On UniVerse on Windows the disallowed characters are encoded so the list can be saved, Kathleene if you check in your SAVEDLISTS directory on Windows you will find where you had an '*' in your name it's encoded as %A, so this is why you don't see the error on UniVerse. UniData does not encode the disallowed characters.​​​------------------------------Jonathan SmithUniData ATS and Principal EngineerRocket Software------------------------------

Continuing on my search for more information about some of the uvconfig settings and their possible real-world tuning outcomes...The OPTMEM setting reads as an important option that could contribute to the performance of all RetrieVe commands.The uvconfig section reads as:# OPTMEM - This is the amount of memory allocated# for the query optimizer's workspace. It is# specified in 1K units (1024 bytes).OPTMEM 64Has anyone ever changed this setting?If so, what setting was used and what impact does/did it have?Thanks------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

I have occasionally wondered what the SCRMIN, SCRMAX and SCRSIZE settings in the uvconfig file actually influence.I know I have never adjusted these values since we started with UV 9 (currently working on our UV 11.3.3 in-place upgrades) so I was wondering if anyone has changed these settings, and if so then to what, and why?From the uvconfig file:# SCRMIN - specifies the minimum size of# UniVerse scratch buffer pool. This# value must be at least 1 and must be# specified before SCRMAX.SCRMIN 3# SCRMAX - specifies the maximum size of# UniVerse scratch buffer pool. This# value must be no smaller than SCRMIN# and must be specified after SCRMIN.SCRMAX 5# SCRSIZE - specifies the size of newly# allocated internal scratch buffers. This# value must not be smaller than 512 and# values greater than 2048 are not advised.SCRSIZE 512------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

HelloI'll check performance and CPU charge of program.Usually I use this$OOTIONS TIME.MILLISECONDST=SYSTEM(12)DO...PRINT SYSTEM(12)-TIts about e execution time but I'll identify the CPU charge... To use efficient instructions because the program run for large qty if users. May I use SYSTEM(9) instead system 12?Thanks for any suggestions.------------------------------Manu Fernandes------------------------------

I am in the process of debugging several hundred calls from UniObjects to host routines. I wrote a debug program that gives me SYSTEM(11), the call stack and other items that are written to a file. The problem is that when I sort the file by the CPU time (SYSTEM(11)) there are several (5) calls all at the same time. Is there a way to get a time that has a higher resolution than just  milliseconds?TIA,Steve------------------------------Steve MayoSoftware Engineerbasys------------------------------

Hi There,I have a retrieve sentence that displays the Loan officers number but I also want to display the officer's name.                                                                                                                   I would like to lookup officer's name in another file. Both files can be related using the operator number.The file I am using is APPLICI need to create a dictionary in that file to lookup the officer's name in PR.USER file.Name is the ID  in PR.USER file.Sample of my output APPLIC Id.... LOAN NO.  LO_OFFICER APPLIED....   LOAN AMOUNT Sts Branch  31786L1.2     687168          1012   15 JUN 21      1,025.00   5      6 3981L1        687182          1074   15 JUN 21        275.00   5      6 Please if anyone knows how to create this dictionary would be of great help.RegardsFrancis------------------------------Francis AquilaCore Banking Support OfficerTISAPapua New Guinea------------------------------

Can someone point me to a download link for UV PE for Windows if it still exists. I've had a look on the Rocket site on the only mention I can see is in the AWS Integration Server instance they're promoting.I want to attempt to set up a Windows Docker instance of UV (to use with a build pipeline). Has anyone done something like this? Should I bother?------------------------------Stuart Boydell------------------------------

Hi All, is anyone using Wintegrate in conjunction with MFA? We're looking to implement DUO to do Radius based authentication. We are using Wintegrate v6.3.6 (Local Clients) to connect to Unidata for Windows (8.2.1. build 9104).I'm thinking we'd login in via Wintegrate as usual, but within the login voc we'd interact with DUO at that stage to do a push to mobile devices etc. for verification.I'd be interested to know if any other users have this in place.------------------------------Norrie SteeleMainetti UK Limited------------------------------

Generating a date in UTC Date Format The data format for an external entity we were supplying data to had changed. They changed the date format from the international YYYYMMDD format to the UTC format. D3 does not have an intrinsic conversion for this format, so I had to come up with a way of generating this date format. After some research, I found a command using PowerShell that could provide me with this date format, but on execution from within D3 I found it to be too slow, especially in a loop. I needed to use only D3 to create the date format to ensure optimal speed. One of the things to keep in mind is whether daylight savings time is in effect (or not). Again, D3 does not provide this info and calling a Powershell script was just too slow. I had to find a way to store a flag in D3 which could be used by a D3 subroutine to know about daylight savings time (DST) and produce the date in UTC format. My idea was to set a DST flag in D3 once a day when the user logs in. This flag can

Does any member have any practical experience embedding a .NET control into SBXA Application.  Something with a User Interface aspect like a rich text control, RIBBON control, chart etc?#SB/XA------------------------------Aaron GloverDirectorHealthinc Pty LtdNeutral Bay NSW Australia------------------------------​​​​