Rocket MultiValue

Hy... a situation, i need to know what week of the month a date is, for example if it is the 1st week of the month, if the second week of the month, if it is the third week, fourth or fifth week of the month for a specific date, in addition of this I need to know for the same date which is the week of the year.. for example if it is the 20th week of the 21st month so on, looking at the OCONV documentation for the mask date, I found only the options for the day of the week and for quarter of the year. Does anyone have any simpler suggestions to find out this information? for now the only solution I found was to loop for the entire year and calculate this, but this is impractical, as I will have to store a "calendar" in the databasei'm using d3 linux 10.2

Is there a way to relate the spot this subroutine is stuck (source line number?) from the layer stack output.  example:Layer type....... Program name.................... Address...BASIC run machine MC.CUST.MATCHCODE 0x00000BE4BASIC run machine CAT.REQUEST 0x00001134BASIC run machine CatRequest 0x0000074EBASIC run machine WW.METHOD 0x0000084CBASIC run machine WW.OBJECT 0x00000508BASIC run machine SPIDER 0x0000443EHaving a problem with this subroutine getting stuck for hours.Appreciate any ideas.Nelson

Does anyone know an easy way to tell if a large file copy is complete?  we have many programs creating/copying files to Type 19 directories and we also have a main program scanning these directories to ftp files to Windows servers to make them available for users.  We need to make sure the main scan program does not pick up a file until the copy is complete.We are on Linux, Universe 11.1.3.

Some Background.Have been developing in UV  platform since VB6 and asp classNow I would like to move on to the latest .NET 5.0 (and future)2 Issues/Question:1. Which client/connectivity should I use..?2. Is there any tool/library where I can convert UniVerse Dynamic String to/from Poco (Plain old Clr Object) or JSON string ? Thank you.------------------------------Koon MIng FongMrRocket Forum Shared Account------------------------------

hi rocket-mvbasic team,I'm working on a development server which execute universe and WindowsTerminalServer.I connect with Remote Desktop and use vscode into the RemoteDesktop Session..I define the vscode 'open folder' at a uv account level, I edit the code in-place from source. the account have 1942 elements , 148 directory, 19 source directory  the .rmv\\catalog\\catalog.cache reference 5226 lines , 1637 FILE, 3595 CONFIGthe rocket-mvbasic extension is really slow to load the 'intelliType' drop list (16seconds on OPEN)  - UNUSABLE Formater is really slow too. >15secOne good new, high CPU by Java is not anymore a trouble. If I copy the 'current' edited sourcode into a separate/isolated folder (userid/Documents/source)  there is no speed problem. One good new, high CPU by Java is not anymore a troubl------------------------------Manu Fernandes------------------------------

hi rocket-mvbasic team,Thanks for the CodeLens fuction. may I ask for a 'language switch' to turn it on/off ?  settings.json "rocket-mvbasic.referencesCodeLens.showOnAllFunctions": false/true on large source code review, it can be annoying, but let the editor.action.peekDefinition, editor.action.referenceSearch.trigger, codelens.showLensesInCurrentLine commands actives !I know I can turn "editor.codeLens": false/true but it apply to all languages.the best will be a command 'rocket-mvbasic.showCodeLensonCurrentFile'  setinto a 'right click option' or shortcutkey  to turn it on/off on the current source code only !thanks------------------------------Manu Fernandes------------------------------

There is still missing internal functions not correctly recognized by the system. 1- Referenced undefined function: SET.PTR call !SET.PTR( channel$getval    , 250 , 100 , 0 , 0 , 3 , 'BANNER ':appid:'_getval.txt,BRIEF' ) 2- Referenced undefined function: UDOGetLastError  ERR2 = UDOGetLastError(ERR.CODE,ERR.MESSAGE) 3- Referenced undefined function: inOAS ... which is a internal source code declared subroutine but the outline knows it as a function  main: a = '' call insOAS(a) stop subroutine insOAS(a) crt a return ​ 4- Referenced undefined function: SB.FILEVAR.S  ; where SB.FILEVAR.S is declared into .rmv/documentation/u

Hi rocket-mvbasic team,Thank you for your great job. I'll put a feed back about a syntax which is not recognized by the language server' which have two troubles : 1/ the formatter makes bad indent 2/ the problems view report errors here is the sample I'm used to code .  open 'accumulator' to F.accumulator else stop open 'datafile' to F.datafile else stop //* take the next accumulator readu accumulator from F.accumulator, 'accu1' else accumulator = 1 loop while read dummy from F.datafile,accumulator do accumulator+=1 repeat write accumulator on F.accumulator, 'accu1' //* loop on all record of a file select F.datafile to s loop while readnext k from s do read record from F.datafile, k else continue * ... repeat ​ here is the trouble, the system return / format

Hi, I receive the update to the release 1.1.2 - fine.Can you list the enhancement / fix of the release ? Can we provide problems feeback ? With kind regardsmanu Fernandes

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 lar

Hi All,Is there still a U2 personal edition available? If yes, what are the restrictions on use?Thanks In AdvanceCheers Aaron

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 tex

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

Just wondering whether there should be an 'SB/XA' tag for this forum?#SB/XA​​

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.

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.

Hi,I'm fairly new to MVIS and I'm planning to enable Okta based authentication for all incoming request to my UV (v11.3.1) . This authentication method will be a token based authentication where a user will submit "client id" and "client secret" to generate a token (valid for a day) , which will be used to get the details from my UV files.I can see an option as "HTTP" authentication in MVIS with option as "OAuth"  but it only allows a filepath to be entered, which may not work with dynamic tokens.Has someone implemented a similar Okta based Authentication with MVIS and can share some thoughts on how to achieve token based authentication.Thanks,Amarendra

Hi All Assuming I have appropriate permissions on the file system can anyone tell me if it is possible to copy/move from a UNIBASIC program?I have explored READBLK and WRITEBLK but the file always seems to be corrupt after writing.Example scenario; move/copy a word doc or PDF file from one directory to another.Alternatively is there a way to shell execute a command to the local server or execute a powershell command etc.Thanks In AdvanceAaron