Rocket® D3® and jBASE®

Hi there.Hope you can help!I am trying to setup the profile so that when the user click clone on a tab it will autologin. I have tried recording a macro and then replaying the macro but this just opens a new window without connecting the terminal or logging in.If I go to script editor and press play it works as intended but I need this to work by right clicking the tab and cloning with an autologin. I am running AccuTerm 8.1 standard. Any help much appreciated!!Thanks

 Accuterm seems to allow greater that 31 days in a month for date fields !! Traits for a form - if we select return will wok in a multi line text box - we seem to just complete the form - not stay in the multi line box anybody seen these problems and are there answers ?

Just putting this out there. I’ve had a couple of cases where people upgraded D3 to 10.3.3 or 10.3.4 and started having weird problems with MVSP. In both cases, we upgraded MVSP to 1.8.21 and it solved the issue. When upgrading D3, it’s not good to simply restore your existing MVSP account, especially if you’re going to 10.4. Anybody out there ready to upgrade, please contact me so I can get you the MVSP 1.8.21 version and help you install it. The reason it’s not posted in the RCP Downloads is because the pseudo tape is NOT a patch but rather an account-save, and the steps are different. We can post all day long, but afraid that the instructions will not get read and someone will try to use it as a patch.Most of you know where to find me (bcram@rocketsoftware.com) and many of you already have my cell phone number. If you can’t get to me by other means, just reply to this and I’ll reach out.

Hello,I want to retrieve parameters of my command tcl in a proc.How can you this ?For example :I execute a proc named PROC01 with parameters.I want to know the parameters to use inside the proc.  A proc :PROC01001 PQ002 HSET-DEVICE003 <how to use parameters line command ?>004 PH005 ...  And execute this in prompt :: PROC01 6 In Basic programs, you can use tclread. But, with proc, how to do this ?  Thanks for your response, 

All,Currently we are extracting out JSON data character by character and saving the data in d3.  That works fine for small records.  But, now we are looking at converting a record with the size of 3,147,865.  Character by character manipulation of a string is very cumbersome.   Is there a JSON to d3 program out there that could handle this or does someone have any ideas?Ted Hurlbut

Is there any ETA on when MVSP for Linux - specifically .NET is going to be available? Thanks! g.------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

A couple of posts outlining how I go about importing and exporting things, I use /etc/passwd as the example as I needed a script to move some users over. I have a bash script to do this but moving more of my workflow into Pick is my goal.  Importing into Pick: https://krowemoh.com/devlog/importing-linux-files-into-pick-.html Exporting out of Pick:

Hi Guys, So we're migrating to D3 we have had initial success following the online documentation but just wondering if anyone else out there has done the same and has any tip or advise for a smooth transition. Thanks in advance Steve------------------------------Steven ReidDeveloperSandiford Solutions LtdManchester GB------------------------------

Watching videos, starting to use the cli. for example, I want to find the customers table (correct my terminology if you don't call them tables).  I entered "listf" didn't see a customers table. Saw users ...entered list users..saw the system users. Cool How do I find the accounts or folder where the customers /cust table lives? If you need more info, please let me know thanks ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

Ok,  chasing my tail for a bit on this one.   RC = 5061.10 LL = 5061.1 IF LL = RC THEN CRT "WHY, THEY ARE NOT EQUAL" END They don't match!  why does it drop the 0 on the compare?  What is the correct way to fix. ------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT US------------------------------

I read through the documentation and compared it to what I am seeing on the system. There is a DEVICES record called OKIDATA.  This has control character definitions and such. In the USER-COLD-START, there is a STARTPTR 0, 0, 0, S13 & STARTPTR 1, 1, 0, S10 and other for the rest. There is also an ASSIGNFQ 1,OKIDATA (C If I do LISTPTR I have several printers, 0, 1, 2, 6 and 7 and all say serial and DEV or PROCESS # is 13, 10, 11, 14 and 9.On the server itself, the OKIDATA printer name is OKI-C711-DCA9AC. How is the OKI-C711-DCA9AC assign to the OKIDATA?  I am thinking it is something to do with a configuration somewhere for the Dev or Process, but not sure what.  Any help would be greatly appreciated.------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

We're excited to announce the availability of the Rocket® MultiValue Developer Assistant. This AI-infused assistant enhances MV BASIC proficiency and developer productivity. See below for key features and requirements. For more details, read the Developer Assistant datasheet and register to gain access. The MultiValue Developer Assistant version 1.1.0.0, integrated within the VS Code® Integrated Development Environment (IDE), allows you to: Generate MV BASIC code via natural language queries. Autocomplete MV BASIC code. Explain MV BASIC code in natural language. Generate comments for existing MV BA

We're excited to announce the availability of the Rocket® MultiValue Developer Assistant. This AI-infused assistant enhances MV BASIC proficiency and developer productivity. See below for key features and requirements. For more details, read the Developer Assistant datasheet and register to gain access. The MultiValue Developer Assistant version 1.1.0.0, integrated within the VS Code® Integrated Development Environment (IDE), allows you to: Generate MV BASIC code via natural language queries. Autocomplete MV BASIC code. Explain MV BASIC code in natural language. Generate comments for existing MV BA

Before upgrading 10.4.0 or earlier versions of D3 Windows, shut down and do a "standard" uninstall of D3. This will leave all of your data and Device Manager settings in place. This is necessary because of a bug in the 10.4.0.1 installer which will not allow installation of the D3 services once the upgrade is complete.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I opened case 01108919 for the subject. In few words: fresh installa works, update not. Cause:  a lot of files are not updated. Best regards Stefano------------------------------Stefano MaranSenior programmerGTN SpATavagnacco IT------------------------------

Hi everyone, I'm very new to Host Access and D3. We're currently working in a D3 Pick environment using the TCL (Terminal Command Language) prompt, and I need to learn everything from scratch. I do have access to Rocket Software's D3 reference manuals, but they're quite large and a bit overwhelming to read cover to cover. Could anyone please suggest the best places to find learning materials - especially video tutorials that cover basic concepts, TCL commands, creating simple programs, and understanding how everything works with real examples? I really prefer videos or more practical, hands-on resources rather than just manuals. Thanks so much in advance for your help!----------------------------

A Collaborative Hub for Modernization and Big Ideas We're excited to launch the Rocket MultiValue Innovation Library - a dynamic, shared forum where MV developers, architects, and innovators can showcase and exchange forward-thinking ideas, prototypes, use cases, tools, and more. This is your space to Share groundbreaking concepts Contribute working demos or prototypes Explore real-world use cases Collaborate with the broader MV community Whether you're looking to modernize legacy applications, experiment with new integrations, or simply spark inspiration, the Innovation Library is designed to accelerate innovation across the MV ecosystem. Join us in building the future of MultiValue — one idea at a time.

A Collaborative Hub for Modernization and Big Ideas We're excited to launch the Rocket MultiValue Innovation Library - a dynamic, shared forum where MV developers, architects, and innovators can showcase and exchange forward-thinking ideas, prototypes, use cases, tools, and more. This is your space to Share groundbreaking concepts Contribute working demos or prototypes Explore real-world use cases Collaborate with the broader MV community Whether you're looking to modernize legacy applications, experiment with new integrations, or simply spark inspiration, the Innovation Library is designed to accelerate innovation across the MV ecosystem. Join us in building the future of MultiValue — one idea at a time.

Can I call a proc from a paragraph? ie,  I want to replace the logon proc PQ [MVSP.PROCS MVSP.ACCOUNT.CHECK] . . . . ------------------------------Paul ReeseIT ManagerPhoenix Systems Group IncYoungstown OH US------------------------------

I have a few vb apps in place.  My latest one of works in vb 2022 but fails when when I install it in on another computer. Here is my code bit: Global:  Private MVSP As MVSP.PickPrivate MVSPFunc As New MVSP.Functions In form load:    Try       '  pool = New rocketsoftware.MVSP.PickPool()        MVSP = New MVSP.Pick       Display("Run Time Type" & MVSP.GetType().ToString)   Catch ex As Exception       Me.Show()       Display("MVSP Failed to init")       MsgBox("MVSP Init Error" & ex.Message)       BtQuit.PerformClick()   End Try The mvsp = new line is failing with error msg: Init Error int path is empty. I installed the d3client 103.4 on the computer, as well as c++ runtime. Nothing changes. I also installed .net 8 runtime  with the install. What strangeness is this?------------------------------David W

I recently was part of a discussion regarding the use of parenthesis with a SELECT statement. My understanding was that parenthesis were not evaluated with respect to AND and OR logic. Is that correct? Looking in the online documentation, the only mention (that I could find) regarding parenthesis use was in relation to OPTIONS. Specifically the the open parenthesis indicated the beginning of an OPTIONS clause and that a close parenthesis could be used to end the clause and that the OPTIONS clause should always be at the end of the statement. If that is the only allowed use for parenthesis then: Why are parenthesis allowed to be used at all in a SELECT statement as follows:SELECT FILE WITH 1 EQ "ABC" AND ( WITH 2 EQ "123" OR WITH 3 EQ "XYZ" )This command executes without an error? Using a file with the following records: TEST..... A1....... A2... 100        A       &n

Ever get on a D3 system and run WHERE LZ looking for stuff but get barraged by PIBs in some normal status? I got tired of that and wrote a BP that goes through WHERE LZ output and strips out the trivial stuff. Posting it here for anyone's use, but also to get opinions on improvements. Don't be shy!!* whereLZ - bsc -09/05/2024** ver 1.1 - bsc - 06/05/2025 - detect if hot backup secondary*tclread wCmdslpTim = field(wCmd," ",2)'cn' ;* set sleep secondsif slpTim else slpTim = 2      ;* default is 2passes = field(wCmd," ",3)'cn' ;* set number of passesif passes else passes = 3      ;* default is 3isSecondary = 1 ;* call checkFHBRole(isSecondary)for passNo = 1 to passes  crt "Pass ":passNo  execute \\where lz\\ capturing whereTxt  aMax = dcount(whereTxt,@am)  for aX = 4 to aMax    line = whereTxt<aX>    if index(line,"inconsis",1) then      crt line ;* corrupt FCB/DCB/wh

I have an Access database that currently connects to the SQLDEMO tables. That's great. When I look at the server running D3, I see the SQLDEMO folder in the D3Databases folder. Fine So now I want to connect to some live data. Specifically the inventory tables. I have lots of documentation, but I can't seem to find the steps to make the tables visible to my odbc dsn. The folder I think I am after is the MISPR folder. If I'm correct, how do I get access to the values in the tables? I was told I need to define a translation table..yes/no Regards ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

What's the most efficient/fastest way to securely get data in/out of a jBase system? The last time I had to do this, we wrote a CGI interface and accessed the system via HTTPS. This time, we have no need for the full CGI environment, we just need to parse some JSON data, and return a JSON response.  Similarly, MVIS is overkill. Is there a "jClient", like there is with qm? We could just listen to a port, but the inbound connections will be coming from multiple clients, so we really don't want to run multiple transactions through the same process. We like the statelessness of separate connections.  Since jBase apps compile to OS executables, the current thought is to establish an ssh connection, with keys, run the appropriate routine, return the JSON and then exit.  We're wondering if there's something simpler.  ------------------------------Raymond DeGennaro