Rocket MultiValue

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

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

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 me

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

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

This link: SELECT Rocketsoftware remove preview SELECT SELECT retrieves data from the database.

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.  

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