Rocket MultiValue

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

Does anyone know what this error is telling me? I see this error come up from time to time and I am not sure what the problem really is. This is Unidata 7.2.9 running on Centos 5.4.  Line 83 of MAIN.PROGRAM is an include, so I find it challenging to find out what it is actually doing when that error hits.  If I step through in the debugger, when it gets to the INCLUDE line it prompts me for the file name where the INCLUDE source resides. When I give it the file name it says that it is not a directory file when it actually is. It won't display the source then.

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 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.  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). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 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.  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). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 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.  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). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 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.  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). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 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.  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). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------