Rocket MultiValue

We have a number of PHP pages that access QM on another server.   Our response time is slow by my standards. we have added some pretty significant logging to our process. We know the pageload time in PHP, we know the time for the function call to QM, and we know the QM response time. We getting some variability in response time as well with no patter that we can see. Our OpenQM server is in Azure and running on W2019. Our web server is on a private server running Apach and linux. we are using our url name and port 8280 as normal http://web.xyz.com:8280/api/ we are seeing times of 1.723 seconds to get the function and pageload in PHP. The QM side takes 8ms . we have been looking that the flush time on MVCONNECT, this seems to make no appreciable difference. we are off checking to make sure nothing on the windows server is grabbing this, such as virus checker or something. we down to internet time. Looking for suggestions on best practices.  Should we make a private tunnel from linux to

Hi Again, I am trying to change the background color of an ITEM , it has FORGROUND and BACKGROUND options in its PROPERTIES when looked at in ACCUTERM. So I am assuming that they can be changed on the "fly" durring use of the form. Here is what I have tried so far           CALL ATGUISETPROP(GUIAPP,GUIFRM,'COMBCUST',GPITEMS,0,0,CUST.LIST,GUIERRORS,GUISTATE)*         RGBCOLOR = 102 + 255*256 + 102*65536*         RGBCOLOR = "Green"*         RGBCOLOR = 102:@SVM:255:@SVM:102         RGBCOLOR = "102,255,102"         CALL ATGUISETITEMPROP(GUIAPP,GUIFRM,'COMBCUST',GPBACKCOLOR,0,0,RGBCOLOR,GUIERRORS,GUISTATE)         IF GUIERRORS<1> >=2 THEN GOTO GUI.ERROR         CALL ATGUISHOW(GUIAPP,GUIFRM,"COMBCUST","",GUIERRORS,GUISTATE)         CALL ATGUIACTIVATE(GUIAPP,GUIFRM,'COMBCUST',GUIERRORS,GUISTATE)         IF GUIERRORS<1> >=2 THEN GOTO GUI.ERROR         It always aborts , as you can see I have tried the RGB raw number, a generic name as used in the Properties drop down, the num

Hi,  am now using Accuterm well but am stumped by the the resulting functionality of the  Combo Box. Lets say the combo Box is waiting for a request and the user enters a Name (as requested)   BAXTER  I then search the Customers file and find 21. When I have created a list and loaded it, how do I make the list shown on the screen so that the user knows that their search request has a result. I realise that the user could simply press the "down arrow" but I would prefer to show them the first 8 items to indicate that the selection is ready for picking  I hope this makes sense. Blessings Chris Baxter------------------------------Chris BAXTERMDCB SoftIPSWICH GB------------------------------

Any U2 Basic program utility available to import JSON object into a dynamic array or Name-Value pair? I expect the U2 program to accept a JSON object as an input, and a list of Variable names to parsed from the JSON object. The output could be a name-value pair.------------------------------suresh anbilOwnerOHM Systems IncCincinnati OH US------------------------------

Hi all:Let's start with "known"<1> *a9999 provides the size of an item<2> Similarly the u7000 user exit returns the size of an item. <3> LEN(My_Variable) returns the length of  My_VariableI need to prevent overflow so I need to defensively check for a certain "overflow" value (to be determined). ByteSize = function{variable}If ByteSize > {a predetermined value} then {defensive code}Else {variable := {continue to build variable } I searched for some function to do this but alas.Does anyone out there have an elegant solution?ThanksStefano

Hi allThis time it's OpenDB.I have a spreadsheet, which I can read in D3 and swap the LF to @Am - we know this. It's a CSV file so I know that the columns are delineated by a semicolon (did this on purpose when I spreadsheet was created (SEP=;)Now, when I create an Oracle table with the column headings I always find myself offset by 1 because the item (that D3 writes) writes the KEY in the first attribute :(Now even if I add this (as a first column) in Oracle - I still seem to not be able to line up the rank (of the D3 attributes) and the columns.Has anyone experienced this?  Let me know if you require the example of the D3 Q pointer but I believe I have this correct. Also, if I write the record with a NUL key - I seem to get inconsistent results.@Robert Burke - any solutions that you may have?ThanksStefano

Has anyone else experienced this?   Since the move to UniData 8.2.4 Build 3003, I cannot use the "BL"  (Break at Line) in the UniBASIC Debugger without getting a mini dump for my troubles. I am unclear if I've just gotten really unlucky, or if something is not working as expected in this build. I have the team I work with opening a case, but wanted to see if this is something that is just my miserable luck, or if something is not quite right. It pretty consistently tells me I have an 'Access violation.  Attempted to 'read from address 0xFFFFFFFF'  ------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

Hi All I''ve just started working with AccuTerm 8. x and as a developer, we sometimes need to break out of code that is processing to debug.Yes, I could place a conditional debug statement in the code but het guess what "Real men don't do that"  :)Anyway - pressing all key sequences (that I know) bears no fruit so I've stopped guessing and put this fwd to this group.I'm running Windows (10 and 11) and set my emulation to Viewpoint onto a Linux installed D3 10. xDoes anyone have the correct key sequence, please?Thanks Stefano

This was highlighted to me by the Director of Development as a feature when we were shipping UniVerse 4.4.4. The command syntax is: verb [DICT] filename [records | FROM list#] … where verb is among 18 options including CHECKSUM, COUNT, and LIST. Do we care if the file name can be almost anywhere in the query? Do we want to advertise this feature in the documentation? Should we just follow the documentation which wants [DICT] filename first? Is this for compatibility with some legacy multivalue environment? Is this capability simply a side effect of the lex/parse implementation? Does anyone do things like the following?: LIST DICT F1 VOC (Split DICT and filename) LIST F1 DICT MD (Filename after fields) LIST VOC DICT (At least this does NOT work – if DICT is not a dictionary field) Thoughts? ------------------------------Mark A BaldridgePrincipal ConsultantThought MirrorNacogdoches, Texas United States------------------------------

As a discussion starter, I'd like to throw out a few wish list items that would be helpful in our environment and, I assume, might be helpful to others:1. Block commentsThere are times when it would be very helpful to have the capability to use block comments. In BASIC programs, using a 'IFDEF()' sort of works but this capability should be available in all source code environments, e.g., BASIC programs, procs, paragraphs, etc. This would allow using markdown for documentation and would simplify program maintenance and management.2. Default text file typeFiles using Type 1 and Type 19 are intended for storing text data. Type 1 is a throwback (way back) to old Pick capabilities and, on current systems (Linux or other) is just another piece of tedium to deal with. I would like to suggest a configuration item that would indicate the type of file to use for standard text files. So, if a new account is created, those system files (like &SAVEDLISTS&) would be created as Type 19, rathe

hello there, I have used Accuterm and Unibasic for the last 4 months, and I used the basic and standard toolboxes from Accuterm 8. That looks like old vintage themes, For Example, I want the input field with the curve edges as well as buttons, and more. So, I want to create a better user interface for my application.is there any alternative or any ideas? Any information you can provide would be highly appreciated. Thank you in advance for your advice. thank you,------------------------------Best Regards,Mohamed AzarudeenRocket Forum Shared Account------------------------------

Our MSP company just started supporting a customer that is using version universe dbms 10.1.3.0 on a windows xp system access from other systems via a terminal program.   XP can print to its windows tcp printers.  Customers accounting APP is no longer able to print, I don't think print job is reaching printer. I started looking at manuals online and another article related to printing but I don't have an understanding how to verify the configuration or how the choice of printer would be made by them when they want to print out various documents versus printing checks. I included a screen shot of what I started exploring using the setptr cmd. Glenn

Hi all, I have just joined. Our company in South Africa runs a D3/SystemBuilderSB+ asset finance application. There is shortage of programmers/developers in the country and I would like to enquire if there are perhaps any programmers or developers who could perhaps assist in supporting our application. Please respond whereafter we could perhaps communicate directly. The ideal situation is if the timeline of interested parties are as close as possible to the GMT+2 timeline. Regards, Derek Gerber ------------------------------Derek GerberMrRocket Forum Shared Account------------------------------

Hi, I am struggling to run SQL statements (UPDATE) on my universe files.  If we run the same command as a root user then the SQL command is successful. This would indicate a permissions problem. Does anyone know which files need to be given permissions to, in order to  allow SQL updates on normal Univere files ? Thanks, Greg------------------------------Greg LivingstonUniverse Practice LeadOUTsurance InsuranceCenturion GA ZA------------------------------

Hi All, Im back to MV-World after a 20-year break. Formerly i was developing an application with advanced Pick / SB+. I want to activate Database triggers on a UV Database for some UV Datafiles to get dependent tables updated. But im struggling right at the beginning. I created  the following: FILE TEST.TRIGGER FILE TYPE 18 BAISC SUBROUTINE B.TESTTRIGGER with the needed parameters. After that I try to activate the Trigger with CREATE TRIGGER TESTTRIGGER BEFORE INSERT OR UPDATE TEST.TRIGGER B.TESTTRIGGER -> I Get the message TEST.TRIGGER unexpected. I thought that I have to convert the file to SQL Table befor so i tried the following command: CONVERT.SQL TEST.TRIGGER -> I Get the Message: Can't run CONVERT.SQL: 'UV11TEST-TL\\Administrator' is not an SQL User So i logged in as Administrator User and tried: GRANT DBA TO t.ludwig or GRANT DBA TO Administrator  -> I Get the message: UniVerse/SQL: "UV11TEST-TL\\Administrator" is not an SQL user.   I think the problem is to get the f

Hello Gang! I'm a newbie with this concept of UniBasic SQL BCI and would like to see if I can find additional resources/examples to help me get "over the proverbial edge". I have read all the the manuals that have material in this subject, but I'm still not comfortable in how to work with is.     My goal here is this...   I would like to use the UniBasic SQL BCI functions/subroutines to retrieve data from a third-party database.   An example of this is to verify a zip code or a geo-code.   I've been programming with UniBasic for many years, but this is the first time that I need to used the UniBasic SQL BCI functions. So, what I'm asking for, if someone could "point me in the right direction" for additional information or examples, that will be very meaningful to me.   Like I stated earlier in my post, I have read the material in the various Rocket documents, but still not quite comfortable in what I need to do. Any feedback will b

Hi, thanks to a few AccuTerm Training YouTube videos I have started to move forward but have hit a problem I cant yet resolve. I am trying to create a screen that show customer details, basic customer info with Rep Code and name (looked up from Reps file)   that's working.   Next step - to be able to update these details, simple stuff works but I am stuck on the Rep Code.   I have created a list box which should show the Rep code but no its blank.    Then I have created a click event which populates the Rep List with code in first column and Name in second that works and allows me to select a different Rep problem is that the new Rep code is not shown, new Rep name is shown via the validate event for the Rep code I simply can not get the Rep Code to show in the box for it  I am sure that I am doing something very simple wrong but cant find it. Can anyone help please  p.s. the training videos get very near the answer but leave it as something for future development of the training app -

This link: SELECT Rocketsoftware remove preview SELECT SELECT retrieves data from the database. View this on Rocketsoftware > Provides some insight as to how to address SQL statement (in D3) I'm looking to do a sample extract - say 10 000 records as we do in "TCL" (select master sampling 10000)The equivalent syntax in SQL is (by example)[see Quora at https://stackoverflow.com/questions/733652/select-a-random-sample-of-results-from-a-query-result] SELECT * FROM emp SAMPLE(25)However executing this in D3 returns a syntax error. can anyone assist, please?RegardsStefano

I have a 5 gig  file that has 7 million records. the record ids are like this : 7060834*11, 5425655*84, 1931679*19. Should this be a hashed file or a dynamic file? Is there a set of rules that should be used to help with the choice?------------------------------[Gary] [Rhodes] [Universe Developer][NPW Companies][Hialeah] [FL] [USA]------------------------------

Help,  I am in desperate need of a 9.0.0 or 9.0.2 installer for client whose system crashed.    Rocket is unable to help as this is the last version from TigerLogic and some contract BS is stopping them from having a copy on their webpage. Anyone out there with a copy, it would be most helpful. Thanks,  Steve Love Computyme PS:  Rocket won't activate  9.0.6 for the same BS reason as not having 9.0.2 -  for other users of 9.0.2 be aware of the lack of availability of this version from Rocket.------------------------------Steve LoveVPComputymeAbington PA US------------------------------

A new FAQ resource is available for AccuTerm customers that need information about the product. The FAQ contains important details about AccuTerm 8.1.1 and below. Whether you want to know how to buy, license, upgrade or many other common inquiries, the FAQ will give you a place to start. I hope you'll find this new resource useful. Please contact the Product Management team or Technical Support if you have suggestions for new entries in the FAQ. ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------

Dear all,Has anyone implemented data encryption at rest using AIX Logical Volume Manager (LVM) with UniVerse?If you have done this, what issues or roadblocks did you find?Thanks,AndrewUltradata Australia Pty LtdThis message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify the sender immediately via return email. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the company.

Hi - and greetings to all the Python "real" men :)I have a problem JUST getting this to work :( I have a Windows machine with this rel of Python installed : It keeps on returning this: What am I doing incorrectly Stefano

What IDE is everyone using for Universe DB to see the data etc... just want to see if there is anything better than dynamic connect?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Introducing UniVerse 11.4.1 – Unleash the Latest New Features!   The Rocket MV team is pleased to announce the release of UniVerse 11.4.1 on August 17th,  2023.    UniVerse 11.4.1, along with MVX Performance 1.7.0, provides an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities.   ·       UniVerse 11.4.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively: o   Utilize the Replication Intelligent Queue Manager in version 11.4 whichallows a subscribing system to recognize multiple updates in the queue for the same file, significantly enhancing performance o   Enable subscribers to receive logs from older protocol levels. This facilitates testing of a newer release of UniVerse on a subscriber while maintaining production on an older release o   Leverage the new uv_repadmin option to facilitate recovery from stalled subscriber groups ·       MVX Performance 1.7.0 integration with UniVerse 11.4