Re: ENGLISH version of SQL TOP command?

What about right a program called TOP. That program would execute the SELECT and then return the first N records specified as an option as an active select list to the calling program? On Tue, Feb 17, 2009 at 2:27 PM, ww w...@waltwhite.com wrote: Tony, You're correct. The only way I can

Re: jBASE 4.1.5.17 on Windows Server 2008 (64-bit)

Just to let everyone know, this problem was answered off-list by jBASE support. Thank you Mike! The resolution was permissions on the c:\jbase4 directory tree. I added modify permissions and now at least I can execute jBASE programs. On to getting my compiler setup. Thanks again. Dick Thiot

Re: Spooler Service on Windows 2008 Server

Dan, Thanks. This sounds more specific to version 4.1 than to Windows Server 2008. We are already using this on Windows Server 2003. The only downside is that we must execute from a telnet session the REST-SPOOLER every time the server is rebooted. I don't remember why right now but it does

Re: jBase : Beginner tutorial

Tony, Top posting because the comments are generic to the topic (mostly). Also, I'm just being a little lazy. I completely agree with your insights about jBASE, their product and resources. Unfortunately, that makes them similar to other Multivalue vendors with the exception of U2 but it isn't

Re: JBase embedded application

You may want to consider application virtualization. I am not sure how it will work with jBASE or the cost. One vendor in this market is InstallFree (www.installfree.com - big surprise there) but they are by no means the only vendor. I know that Pete Schellenbach from Accusoft has used

Re: JBase embedded application

? Dick Thiot Will Johnson -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to jBASE@googlegroups.com To unsubscribe, send

Re: Totally off subject... question about wireless networking

Dave, Did you try a Google search? I found this specs page: http://h18000.www1.hp.com/products/quickspecs/11997_div/11997_div.HTML. It implies that the wireless is either optional or different options might be included. I would suggest looking at your System properties (see Control Panel) then

Re: FW: wlp

David, I am going to jump in here just to say that I have used Print Wizard at a number of sites from replacing PCL-5 printers with more modern printers that no longer support PCL-5 where there is lots of code that depends on PCL-5 to using PMWL to create PDF files on the fly that can be emailed

Re: Slow to despool? (sometimes)

with the vendor. D3 supports up to 2048 queues, and the number of printers can be much higher. I'm not saying there are a lot of sites approaching this size, but enhancements were requested from the field to support limits beyond R83. T From: Dick Thiot Is it typical that jBASE sites

Re: Slow to despool? (sometimes)

Tony, By default I was referring to the way jBASE polls at a set time interval that is based on expecting to have a large number of queues and therefore not adversely affecting performance. Dick On Tue, Nov 8, 2011 at 3:30 PM, Tony Gravagno e09kp5...@sneakemail.comwrote: For reference, I

Re: jbase and vb.net

as opposed to Temenos). It is licensed by developer and per each connection to the database. However, since it supports connection pooling this is not a one-to-one relationship to users. mv.NET is sold through resellers in the U.S. I can't speak for other parts of the world. Dick Thiot Maverick Systems

Re: Listing with MV.

Calvin, You could create a dictionary item that outputs the attribute with the value marks replaced with your delimiter. Dick On Thu, Feb 16, 2012 at 5:09 AM, Md. Abdul Awal Masum masu...@gmail.comwrote: write a routine and save your multivalue data in an array with your specified marker

Re: Pick r83 to jbase conversion

David, Is there a reason to go with jBASE 4 as opposed to jBASE 5? Also, I am not sure about Tony's app but I will venture a guess that it can use Accuterm's concept of intermediary files so that you can transfer out from one system then transfer in at a different time. Dick On Tue, Feb 28,

Re: jBASE Migration to ORACLE

Tunji, Simon asks a good question and I would like to ask it in a different way. Are you wanting to convert data or are you trying to convert your application? Data can be migrated and/or interchanged with Oracle but unless you are well versed in the schema of your data in jBASE you may need the

Re: jBase 5 / Windows 2008R2 / Logging on process

Simon, One issue that we have found with WinSvr2K8R2 is that when files are copied from an untrusted source they are marked by the O/S as blocked. If you select all of the files in Windows Explorer and look at the properties you will see a Unblock button. There is also a way to unblock all

Windows SSH Server

We currently have a need to implement an SSH server for Windows for a jBASE server. Can others on the list let us know how you have approached SSH servers on Windows for jBASE? Thanks, Dick -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to

Re: Windows SSH Server

I guess I should update the group. Thanks for all of the input. We had two requirements for SSH that were driven by security requirements that we must comply with. Telnet is considered an insecure protocol even on internal networks and it not allowed by most current security policies. We have

Re: jBASE migration 3.4 to 5.2 - How difficult?

Kevin, You are probably going from 32-bit to 64-bit. However, if your code is all traditional MV BASIC style code I don't think that you will have a problem. We have struggled because of hooks outside of jBASE that have caused us conversion issues. I don't blame this on jBASE. It is a matter

Re: How to Append Data to the End of Existing File in infobasic

What type of file are you accessing? There are different solutions for the different file types. If the CustomerID is the key to the file and you are using a hashed file then your data shouldn't be overwritten using different CustomerIDs since hashed files require a unique key field and store

Re: Subroutine catalog being ignored

I replied in the other thread of this same topic before I saw this thread. My apologies for any duplications. Dick On Tue, Apr 23, 2013 at 11:02 AM, Mark Hogden m...@proman.com wrote: It's possible that the compilation is going to a different lib than the one in use. Is the env variable

Re: Subroutine Compilation problem

I would suggest a couple of things. You can try the jshow -c yoursubname command to make sure that the subroutine is recognized in one of the libraries. If it is currently being called I would be surprised if this didn't return showing the lib file that the subroutine is in. You can also try to

Re: jbase 3.x on win 7 64 bit

You might want to consider virtualizing their existing 32-bit machines and then running that on the 64-bit machines. Are these workstations or servers? Dick On Wed, Apr 24, 2013 at 9:04 AM, Richard Kann h...@comp-ware.net wrote: Is there a way to install Jbase 3.x on a machine running 64bit

Re: jbase 3.x on win 7 64 bit

of the primary laptop. OPTIONS! Dick On Wed, Apr 24, 2013 at 10:46 AM, Richard Kann h...@comp-ware.net wrote: Server on Jbase but not a windows server. It just is hard to find 32bit machines. Richard Comp-Ware On 4/24/2013 10:21 AM, Dick Thiot wrote: You might want to consider virtualizing

Re: phone interface

Richard, The real question is what do you want to do with your smart device? Do you just want traditional type access to the jBASE system (which is much less than optimal on that device although the tablets do a reasonable job). However, if you are wanting to really control an application on

Re: Subroutine Compilation problem

through all my issues so far, but that is good to know. Sorry for the double post. The first did not show up right away and I thought I did something wrong. On Wednesday, April 24, 2013 8:40:29 AM UTC-5, Dick Thiot wrote: I would suggest a couple of things. You can try the jshow -c yoursubname

Re: SPOOLING TO A PDF PRINTER

Richard, We use Print Wizard very successfully. You need some way to provide a path and file name for the document. There are some other tools out there that work as well but this one is integrated into MultiValue environments quite well including jBASE. There is at least one other MultiValue

Re: How to restart form queue

My jBASE 3 commands are a little rusty however a quick google search for jbase spooler and the first entry that comes up is a link to the jBASE spooler commands for jBASE 3 and within that a link to Restarting the Spooler. The main spooler documentation is at

Re: HOW UPDATE RECORD ON TABLE

On Thu, Aug 15, 2013 at 12:20 PM, Kevin Powick kpow...@gmail.com wrote: On Thursday, 15 August 2013 03:33:38 UTC-4, MChau wrote: Hi . How can I update all record on table using UPDATE-RECORD. * * Is that even a valid command? Kevin, I was thinking that might be a vendor specific

Re: jBase on Win7 vs. Server 2012

Doug, There are so many variables to be considered that relate to your particular installation and how you use your jBase database. Windows Server 2012 is equivalent at a very low level (think kernel) to Windows 8. With that comes a steep learning curve to me. As for any of the Microsoft

Re: PICK R83

David, Are you running the old PICK R83 on a PC? Let's be clear about Dan and Richard's suggestions. VERIFY-SYSTEM (O) will overwrite the existing checksums with the value of the current ABS, not the norm. If you have corrupted or non-standard ABS, the checksums for those ABS is what will be

Re: PICK R83

Tony (and David), First, the TRS-80 Model I rules. Long live the Trash-80! That was my first computer and where I learned BASIC. I converted the old horse race game from a Microdata to the Trash-80 then modified it so that the horses races based on odds then paid off the same way. That is how

Re: moving a jbase4.1 install to another machine

J., Are you under a current support contract with jBASE? Do you have a VAR? Answers to these questions determine how best to proceed. Thanks, Dick On Mon, Dec 9, 2013 at 3:21 PM, J. Bennion bitsu...@gmail.com wrote: We have an old jbase 4.1 install running RHEL 9. The machine where it

Re: Report writer

Ken, Instead of Crystal Reports to create the reports have you considered using Excel? I suspect that your users may be more comfortable with that. There are some tools available that make that easier to work with. See Nebula XLite - http://nebula-rnd.com/products/xlite.htm. OBDC is certainly

Re: BUILD ROUTINE ERROR

Nadia, When you first tried to run jdiag you were in the debugger and not the jsh prompt. jBASE debugger-jshow -c EWBS3.ACC001 The most common cause of this problem is that your subroutine name is different from how you define it in the first line of code. It should be: SUB EWBS3.BLD.ACC001

Re: Migration to jbase5

Sakthi, I think that you are working in an area of jBASE that few of us utilize. I suggest that your best bet for support is Temenos assuming that you have a Temenos support agreement. Dick Thiot On Tue, Feb 3, 2015 at 2:33 AM, சக்திவேல் பழனிசாமி ppsakthi...@gmail.com wrote: Hello Every one

Re: Ye olde 3.4.9 issue on Windows

You mention that you are loathe to change which I read as upgrade jBASE but have you updated/upgraded Windows? What version of Windows is hosting jBASE? On Fri, May 18, 2018 at 4:48 AM, Stuart Elliott wrote: > After spending around 2 years of "coping", then finally

Re: Query Using EVAL on Undefined Row

unt conversions for dates, money or other "formatted" data. The dictionary record to define your column is pretty simple. Do you have access to the system to edit your dictionary? Dick Thiot On Thu, Aug 23, 2018 at 10:30 AM joyce wrote: > All, > > I have the working query state

Re: Query Using EVAL on Undefined Row

o perform queries on the fly and don't > have time to add the definitions. > > I did get another reply from someone suggesting I try the syntax below, > and it works great! Just what I needed! > Instead of PRICE<1,1,1> use @record > > > > On Monday, August 27,

Re: FORM QUEUE NAME and FORM QUEUE NUMBER

Thank you for the replies regarding form queues. Not only have they been helpful to me and I assume others but it is nice to see one of the vendors adding to the forum without wondering if the customer has a support agreement. You know that I have worked with jBASE for a long time but having

Re: Create-file question

Marc, Your create statement assumes that there is already a dictionary section. Are you wanting to create a new data section underneath and existing file or a new file with both dictionary and data sections. Also, I agree with Peter. Get rid of the double-quotes. If the latter then try:

Re: [AD] Texas MultiValue Users Group Holiday Social

show Gas Monkey (go figure!). You can sign-up at https://bit.ly/2PaWq3x. We hope to see lots of you there! On Thu, Nov 29, 2018 at 3:18 PM Dick Thiot wrote: > TEXMUG (Texas MultiValue Users Group) Christmas Party at the Gas Monkey > Bar & Grill! > > Social Time! No Sales Talk! N

[AD] Texas MultiValue Users Group Holiday Social

TEXMUG (Texas MultiValue Users Group) Christmas Party at the Gas Monkey Bar & Grill! Social Time! No Sales Talk! Network! Have Fun! Reconnect! Santa's on his way and scheduled to visit all the TEXMUG boys and girls on December 13th at the Gas Monkey Grill! His elves are out dragging their sack

Re: Problem cataloging subroutines in old version of jbase

jBASE drives off of either environment variables or options on the catalog command to determine which lib file to use. I haven't used the command line options much but if you are interested this should help - https://docs.jbase.com/49435-compilation/jbc. If you are interested in setting

Re: Query doing string math instead of numeric with LT

Joyce, Word of caution... You should be aware that changing the existing dictionary itemss could have an effect on the way other parts of your application work if they are using those same items. If you created new ones then you shouldn't have any problems. Dick On Fri, Jan 10, 2020 at 7:58

Re: NetApp SnapCreator Integration with jBASE

Hello Ben and welcome. It is nice to have someone leveraging modern tools against jBASE. My first question to you is if the customer is under maintenance with Zumasys. If yes, then you can get access to the premier experts on jBASE directly through their support. Dick On Wed, May 6, 2020 at

Re: Get a list of files in a directory?

If this directory exists within your PATH environment then you can just select it and process like any other select list. The other option is to provide the full path to the directory. Are you are Linux, AIX or Windows? On Wed, Aug 18, 2021 at 9:48 AM wsw wrote: > Does anyone have an example

Re: Microsoft SQL connectivity

There is a brand new product on the market called MVsync ( https://prosolgrp.com/mvsync/). This product has many advantages over traditional products to synchronize data to SQL server. Using MVsync, you can then access your MultiValue data using relational tools using your MultiValue

Re: [EXTERNAL] Re: Jbase Response Delay

You might also have a file that is accessed by one of the phantom jobs that is poorly sized. Dick On Tue, Apr 18, 2023 at 17:50 Alan Metz wrote: > Yes, I am familiar with wtmp, thanks for the suggestion! I periodically > clear it, now would be a good time to re-visit!! > (I also clear