Rocket MultiValue

Hi Guys. I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile spent a while searching for the magic number but can't find anything out in the world of Google Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well yesterday the job stopped with  1541766 ROWS I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure Many thanks Andy

hi rocket-mvbasic team,Thank you for your good job.a few trouble I'll share . 1/ if we have multiple include, the outline is badly organized , reflect nodes nested where it's not. 2/ we are used to define multiple and nested include, outline become unusable, totally 'mixed', show tree nodes which are not.... 3/ please in the OUTLINE view, can you put the symbols into a tree-node named like the include record id ?  likethis? - symbol a - symbol b - file/id |- symbol c |- symbol d |- symbol e - file/id |- symbol c |- symbol d |- symbol e |- file/id |- symbol f |- symbol g |- symbol h ...   ------------------------------Manu Fernandes------------------------------

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/universe/custom.json ; hoover / intellitype knows it. (not connected mode) 5- variable not referenced.  variables returned by 'creator' function like me.udo  into if UDOCreate((UDO$OBJECT,me.udo) then   are not listed into OUTLINE as a variable. ------------------------------Manu Fernandes------------------------------

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 it seems, the system do not know we can use then/else statemens------------------------------Manu Fernandes------------------------------

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

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

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