Rocket MultiValue

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

Working with a group of developers, I'd like to modify the system prompt in UniVerse from the standard '>' to include the account in which they are working. The 'WHO' command can give misleading results as it shows the folder in which they are running which may or may not be the UniVerse account. For instance, my developers each have a folder that contains the various accounts that they need for testing and source control. An example might be '/bl1/DEV_ABC/COM' and the 'WHO' command returns 'COM' but the UV.ACCOUNT record for this path is 'COM_ABC'. So, I'd like to modify the system prompt to show 'COM_ABC>'. I would assume that this could be set either in the 'LOGIN' script or in 'UV.LOGIN'. That will provide a visual cue that they are not in a production account. So far, searching the documentation has not produced an answer. TIA!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

For When we can expect Accuterm and GUI services in 64 bits ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

We're testing jBASE 5.9.0.1 and have a hung process that indicates "Program blocked on binary LOCK at OE.SR.DEL.UPDATE,437 Line 437 of that program is attempting to delete a record from the a file. The record is not locked,  jDLS -d -v -L does not indicate any type of lock on the port or process. SHOW-ITEM-LOCKS does not show any type of lock on that port or process-id.  LIST-GROUP-LOCKS shows no locks.   LIST-EXECUTION-LOCKS shows no locks. Anyone have any ideas on how I can identify and resolve this binary lock issue? Thanks.------------------------------Jim EdwardsIT ManagerPlimpton & HillsMeriden CT US------------------------------

Hi My name is Chris Baxter I am trying to get into AccuTerm after several years elapsed from developing a trial screen in AccuTerm 7 but customer not being ready.  They wish to push forward now.    I have downloaded AccuTerm 8 trial and installed the system and Updated the Host Services, also installing the DEMO MENU hoping that I would at least  start to gain understanding from that but  it failed immediately I am not feeling too confident at the moment :( I have uploaded a screen clip as well I hope someone will respond please Regards Chris Baxter chris@cb-soft.co.uk ------------------------------Chris BAXTERMDCB SoftIPSWICH GB------------------------------

Just checking to find out if there are any known issues with installing UniData 8.2.2 on Azure. Just basic database functions required.------------------------------James BrenzaPresidentMate PCSEllicott City MD US------------------------------

Hi, I'm new to SB+ development so please excuse any ignorant questions. I'm trying to amend a screen to: Add a field that should be forced to 'N' unless 2 prior entered fields have particular values. If the prior fields meet the conditions the user should be able to optionally change the value to 'Y' If the prior fields don't meet the condition the user should not be able to change the value. What would be the cleanest/best practice way to achieve this? Regards, Jonathan

HyI have an gui app that load a complex window.. with a lot of information...the basic compect is when click in a row of the grid, its loads values to a lot of componets.... but when the user start to click fest in the rows.. its show the loading window how to imporve ?i 'm using alreday Accuterm 8.1 with the gui apps alreday uptdade, i saw there is some itens in ACCUTERMCRTL file.. it can be used to improve the perfomace ? ------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

Periodically I have to transfer a single file, usually .txt, from D3 to the Desktop. There is a function in SB+ to do this to a Windows Desktop environment, but I want to transfer the file to a Linux Desktop. I have looked at scp, but can't quite understand the source path from the D3 partition. Any ideas or other suggestions welcome. Once I get it working, I intend to establish it as a script in SB+ to be used multiple times. Thanks. Alex ------------------------------Alex PolglazeThe Book-Keeping NetworkPerth Western Australia+61419 776 348apolglaze@book-keepingnetwork.com.auhttps://www.book-keepingnetwork.com.au/------------------------------

Effective September 1st, 2023 many MV product versions will move through the lifecycle.  Versions statuses and dates for each product can be found on the Product Availability Matrix.  Additionally, the MV lifecycle policy and status definitions on available on Rocket Business Connect (RBC). While MV BASIC for VS Code supports only the current GA extension version and does not follow the standard MV Product Lifecycle, please consider the lifecycle changes on other products you use.   The Rocket MultiValue (MV) Product Lifecycle allows customers to plan upgrades so they can take advantage of the modernization and innovation features in fully supported, generally available (GA) product releases.  Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------