Rocket MultiValue

Hi all, we have many web aplications invoqued from some users via unirpc, and sometimes we are out of available licences for interactive users, are there a way in universe to limit the number of connections that each user can start? 

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3? In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED). How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute. The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out! I'd like to know how you may have solved this in a more elegant manner. Regards Stefano

Hello, I am new to Accuterm and the project I am working on requires a date field. Is there any calendar picker component that could be used? The GUI designer does not provide a component like this. I will appreciate any help. Thanks.

I cannot see how to retrieve information returned from a script into my basic program. For example:SCRIPT  = 'width = Field(WindowPos(0),",",3)'CALL WIN.COMSUB(SCRIPT)how do I get the returned information back into my Unidata basic program?

We have hundreds of desktops running wIntegrate version 6.4.4.  After migrating to RHEL we want to find an easy method to enable SSO for all our desktops with wIntegrate.   We would like to run an automated script (using powershell or something) to update all our desktops so we don’t have to update each desktop individually, but the manual states that you cannot edit the session .wic files with a text editor because the files are in a binary format… that you need to use the wIntegrate Editor to edit the .wic files.  This doesn’t sound like something that can be easily automated. We have experimented with using a text editor (Notepad++) to update a .wic file before, and wIntegrate seems to properly recognize the changed setting... so it seems feasible that an automated powershell script could find and update all .wic files with a new setting.  Has anybody else had success updating settings in a wIntegrate .wic session file without using the wIntegrate editor to comp

Introduction I've installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario?

Can anyone explain when the ODBC driver returns a DUP_COUNTERS result?Google very "unhelpful" here :(

Introduction I've also installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines. Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package. What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario? #U2Toolkitfor.Net #EFCore6 #Un

hi everyone,   I created my own application. And it is a desktop application and it works with Unidata and Unibasics. I used Accuterm as an editor for my application. The output of my application screen shows as an old theme when I use Accuterm editor. The button, text, and color make my application old. I try to make my application screen look better. I want to make my application look good with a modern UI, I used Accuterm like Microsoft Visual Basics, Can anyone help me, please Azar

On a Windows system (Windows version is 10.0.20348.1970) running UV 11.2.5 in PICK format, we have a BASIC program that executes a DIR command. EXECUTE "DOS /c DIR" CAPTURING OUTPUT  The time column shows the timestamps in 24 hour format. However from a Windows DOS Command window, if we type DIR the times are in 12 hour format.  My question is how can we get the time format to be in 12 hour format when running the  program? What is UV looking at to determine the time format?  BTW we get same results when we use DOS command at TCL to get to the DOS environment and then type DIR.  Screen shot attached with Windows Command prompt window on left and Accuterm on right. Thanks in advance.

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

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

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

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

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

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

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

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.

Hi all. I have the following ODBC driver installed : And I'm receiving the following message from OpenDB "[Rocket Software][ODBC D3 Driver]Logon failed. Check D3 connection parameters and available licenses. {28000}" Any Ideas on how to resolve this? (assuming that there are available licenses) - What is "required" for the D3 connection parameters? IOW - for example - Is a password necessary - and again here I understand that a password is recommended but for the case of clarity - is the password required?Furthermore - is there an ODBC v3.0+ available for D3? (yet) Thanks StefanoThanks

Hello! Unidata 8.2.3 on Windows 2019. Im using putty and cmd and when i attempt to do a LIST on anything it will output results with the prompt "press enter to continue" once i do that it removes the results it just gave me and outputs the next 10 results or so until the LIST is complete. Im hoping there is a setting that would make it so that it would NOT remove the results in the LIST so that i could scroll up and see all results. any ideas on this?

UniVerse 11.3.1 on AIX. In addition to changing mod to read-only, for example, I need a list of things that can be done to a type 18 file that will result in "Fwrite failed at DBwrite" when using the WRITE statement. 

Hello  UV 11.3 on Windows,  His anyone understand the WARNING: Old style truncated data level name "FORTRAE/MARLA.TRAE.104" detected.  on open file.  The VOC is a classic multi-data level defn, where the dalalevel filename is really  MARLA.TRAE.104.... Any idea ? Mamu

I have many account that I work with (UV 11.3.4). I am looking into using BDT and it works fine for a single account. All features work. However if I try to move to another account I get an error message stating: Could not change account to ### on server ###. The account path does not exist, or you do not have enough privileges to access the account path. I close BDT and re-open BDT and I can open the account just fine.  Am I doing something wrong here? We tried using Visual Code, however there were issues we could not overcome. Jon

Hi Everyone, Been a while since my last interaction here and have been up to my armpits in it all. Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks. Regards, Peter