Re: [RBASE-L] - out of dynamic space epilog

Happy New Year, Jim and all. Fifteen years ago or so, I had a client with that problem popping up frequently. The problem went away when they re-cabled the office. Bill On Thu, Dec 29, 2022 at 9:25 AM 'jim schmitt' via RBASE-L < rbase-l@googlegroups.com> wrote: > Thanks to Karen, Razzak,

Re: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group

For anyone who has to use FB, but wants to maximize personal privacy and security, here are some recent instructions: https://www.consumerreports.org/privacy/facebook-privacy-settings-a1775535782/ Bill (sent from mobile phone) On Tue, Dec 14, 2021, 8:10 PM Mark Lindner wrote: > I agree. I

Re: [RBASE-L] - SQL: Column Value for MAX(Date)

Doug, Does this work? CREATE VIEW TrailerMaxDates (TrailerID, MaxDate) AS + SELECT TrailerID,MAX(TrailerDate) FROM TrailerInfo GROUP BY TrailerID SELECT t1.*, t2.TrailerLoc + FROM TrailerMaxDates t1, TrailerInfo t2 + WHERE t1.TrailerID = t2.TrailerID + AND t1.MaxDate = t2.TrailerDate Bill

Re: [RBASE-L] - Re: SQL book

I'm well, Tony. I've been fully retired for 3 years now (except for one weekend for an R:BASE Conference in Las Vegas!). I still use my R:BASE mugs, shirts, pens, portfolios, flashlights and other things all the time. I don't use R:BASE much any more, except for a grocery shopping list

Re: [RBASE-L] - SQL book

Your last name wasn't on your email. You aren't by any chance Thom Cimicato, of the SWORBUGS, are you? Bill On Thu, Jan 21, 2021 at 11:46 AM Thom wrote: > Decades ago there were two SQL books/manuals specific to R:Base written > by some top developer(s) that was available to the R:Base

Re: [RBASE-L] - SQL book

I was a co-author of those books, with David M. Blocker. I'm afraid they are beyond recovery. The last versions were written in Ami Pro, WordStar, or maybe even the Describe word processor on OS/2, and self-published by David. Even if we could find the source files, I'm not sure we could read

Re: [RBASE-L] - Bill Eyring

I'm so sorry to hear this. Thanks for sharing it, Doug. Bill was a fun and engaged part of many developers' conference. Bill D. On Sat, May 9, 2020 at 9:40 PM wrote: > Bill helped with the programming needs of Catholic Cemeteries in Long > Island New York. > He helped support their

Re: [RBASE-L] - My first day in the Home Office (No, not in the British sense!)

Lovely memory from a great fellow. Thanks, Razzak. Bill > > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving

Re: [RBASE-L] - SQL Help - OT

Unfortunately for you, Paul, the SQL definition of a table is "an unordered set of rows." So the concept of a "next row" is problematic to building a query. Your query provides the order through the ORDER BY clause. Will the ID2 column match a ID1 column more than once in the table? I'd be

Re: [RBASE-L] - Limit inserts to one of many

Hi, Doug! What about: INSERT into Inventory (ItemCode,Description) SELECT *DISTINCT* ItemCode,Description + FROM Orders + WHERE ItemCode in (SELECT ItemCode from NewItems) (sent from Moto Z) On Fri, Aug 3, 2018, 9:00 PM Doug Hamilton wrote: > My SQL brain cell is stumped. > > We have a

Re: [RBASE-L] - Blank date value

> > Claudine: does the database see them as null? If you did a select where > datecol is null, do they show up? > > Karen > > > > -Original Message- > From: Bill Downall <b...@downall.us> > To: rbase-l <rbase-l@googlegroups.com> > Sent: Fri, May

Re: [RBASE-L] - R:BASE Technologies, Inc. - Special Announcement

Claudine, I know! Me too. But he said Wednesday, May 16 at 3:00 pm. And that hasn't happened yet. Bill On Tue, May 15, 2018 at 3:15 PM, Claudine Robbins wrote: > Like a kid waiting for Santa... Did I miss it or was there no > TipoftheDayDigest_2017.pdf? > > Claudine

Re: [RBASE-L] - Android App

Fantastic! If I weren't retiring in 20 days, I'd be asking for details. Thanks, Tommy of "Tommy and the Sworbugs." Happy holidays. Bill (sent from Moto Z) On Dec 11, 2017 7:16 PM, "THOMAS CIMICATO" wrote: > I just want to brag here and see if anybody else has

Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 3

Nice new features in R:BASE, and also a great new interface for rbaseupdates.com! Bill On Thu, Sep 7, 2017 at 12:00 AM, A. Razzak Memon wrote: > Thursday, September 07, 2017 > > To All Users of R:BASE X and R:BASE X Enterprise (Version 10): > > Official updates of R:BASE

Re: [RBASE-L] - get the minimum and store it

Dan, Here are some ways to gather aggregates from your view: SELECT loczipcode, dlrnum, MIN (distance) FROM viewname GROUP BY loczipcode, dlrnum SELECT loczipcode, COUNT (DISTINCT Dlrnum), MIN (distance) FROM ViewName GROUP BY loczipcode SELECT LocZipCode, COUNT (DISTINCT DlrNum), MIN

Re: [RBASE-L] - count updates, save excel file

Chaya, Welcome. For #1: SET VAR vUpdatesCounted INTEGER = NULL SET FEEDBACK ON UPDATE tablename SET VAR vUpdatesCounted = .RBTI_RowsUpdated Bill On Thu, May 25, 2017 at 4:12 PM, Chaya Goldberg wrote: > Hi, thanks for this list. It’s my first time writing in.

Re: [RBASE-L] - Quickbooks

I've built a bridge between R:BASE and QB through a 3rd party product called Transaction Pro Importer out of Bay State Consulting. It's been working well for years, but Karen is right: when QB gets upgraded or moved from desktop to cloud, the TPI product may have to change and the R:BASE end

Re: [RBASE-L] - SPAM

Steve's analysis is good in a lot of cases, but this one is different. I received the email purporting to be from Javier. Javier was not in my contacts list at the time, and I was not in his. So changing our email passwords will not stop this particular exploit. What we have in common is that we

Fwd: [RBASE-L] - "In the Cloud" sound effects

Thanks, Dan. You got me looking in the right places. All I had to do was go into the server's services settings and set the "Windows Audio" and "Windows Audio Endpoint Builder" services to start automatically. The redirection apparently was already set. By the way, that was Sami Aaron's wav file,

Re: [RBASE-L] - "In the Cloud" sound effects

pr 21, 2017 at 11:14 AM, Bill Downall <b...@downall.us> wrote: > Thanks, Dan. You got me looking in the right places. All I had to do was > go into the server's services settings and set the "Windows Audio" and > "Windows Audio Endpoint Builder" services to start

Re: [RBASE-L] - "In the Cloud" sound effects

21, 2017 at 11:04 AM, Alastair Burr <adbb...@outlook.com> wrote: > SET ETHEREAL_SOUNDS ON, maybe? > > Regards, > Alastair. > > On 21/04/2017 18:52, Bill Downall wrote: > > I have an app that was converted to a cloud app recently. > > We just noticed that sound

[RBASE-L] - "In the Cloud" sound effects

I have an app that was converted to a cloud app recently. We just noticed that sounds that have always alerted people to data entry issues no longer sound on the local computer. I presume if anyone were standing (floating?) next to the server-in-the-cloud they would hear the sound. Is that

Re: [RBASE-L] - RIP Bob Castanaro

2 > > Home: 913-397-9605 <(913)%20397-9605> > > Office: 913-829-0888 <(913)%20829-0888> > > Cell: 913-915-3137 <(913)%20915-3137> > > > > *From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] *On > Behalf Of *Bill Downall > *S

Re: [RBASE-L] - Simple SELECT statement: Bad Brains

Create temp view MonthBreakout (EntryDate, EntryCount, EntryMonth) + AS SELECT EntryDate, EntryCount, (IMON(EntryDate)) + FROM tablename SELECT EntryMonth, SUM(EntryCount) from MonthBreakout + WHERE blah blah + GROUP BY EntryMonth On Wed, Dec 21, 2016 at 1:40 PM, Bruce Chitiea

Re: [RBASE-L] - Printing opinions?

And a 500 page PDF will overwhelm printer memory just as easily as a 500 page pcl stream. Bill On Tue, Nov 8, 2016 at 9:16 AM, Bill Downall <b...@downall.us> wrote: > I think you have a good solution. Once you have the cursor set up, it will > be little effort to create and adjust a

Re: [RBASE-L] - Printing opinions?

I think you have a good solution. Once you have the cursor set up, it will be little effort to create and adjust a timing loop to wait for the printer to catch up. A new printer, with a lot of memory and nice envelope handling, would probably cost little more than the time they would pay you for.

Re: [RBASE-L] - R prompt editing

David, I don't think there is a way to do that, but you could create a simple grid-based form (named BuildingCost) and type "EDIT USING BuildingCost WHERE BuildingNumber='47' Bill On Tue, Jun 14, 2016 at 9:04 AM, Fitts, David A. wrote: > Greetings everyone, > > > >

Re: [RBASE-L] - speeding up searches in a view

Mike, If you went to the grocery store intending to buy 3 items, and you knew ahead of time exactly where they were located, it would take you three or five minutes. If you went to a grocery store in a foreign country, where there were no signs over aisles that you could read, and things were