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, Rand
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 h
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
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
application.
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 Communit
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
eithe
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 programming
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
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 workin
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 bunch
orm.
>
> 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
> To: rbase-l
> Sent: Fri, May 25, 2018 7:19 am
> Subject: Re: [RBASE-L] - Bla
Claudine,
If you can write a WHERE clause that finds all the bad dates, you should be
able to write an UPDATE that fixes them.
Are all the wrong dates off by exactly a century? If not, you will have to
make your WHERE clause more complicated, and do this more than once.
SELECT datecolumn FROM ta
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 :-)
>
> -Original Mess
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 used RBase this
> way
>
> My
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 X/R:BASE X Enterprise (
Hi, Paul,
In R:BASE, you can use the #3 notation to select the column that is
physically the third column in a table. Does that work with an SATTACHED
table, too?
SELECT #7, #3 FROM dbo.SALES_REP
Bill
On Thu, Aug 3, 2017 at 1:22 PM, Paul C. Buckley
wrote:
> Albert,
>
>
>
> I don’t see a way t
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 (di
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.
>
> I have two questions:
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 rework
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 a
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,
wrong."
On Fri, Apr 21, 2017 at 11:14 AM, Bill Downall 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
Apr 21, 2017 at 11:04 AM, Alastair Burr 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 sounds that have always alert
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 accura
LOL. You teaser!
On Thu, Jan 19, 2017 at 2:12 AM, A. Razzak Memon wrote:
> Oops!
>
> That was supposed to be for my development team!
>
>
> Razzak
>
> --
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop recei
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
After a grueling battle with cancer, long-time R:BASE developer Bob
Castanaro, from Barberton, OH, died this week. He chose to stop dialysis a
little over a week ago, and, as he said, to say goodbye on his own terms.
I always enjoyed playful, friendly, respectful political disagreements
with Bob
I got auto-corrected. Should have been LISTOF(colname) .
(sent from Moto Z)
On Dec 21, 2016 8:29 PM, "jan johansen" wrote:
> Bill,
>
> Good point.
> Let me explore one to many form.
>
> Jan
>
>
> -----Original Message-
> From: Bill Downall
> T
Relational purist that I am, I would use a many-side table with a row for
each job function for an employee. Indexes would retrieve everybody with a
particular job function quickly. And a "SELECT List of (colname)" would get
you your comma-separated list if and when you need it.
(sent from Moto Z
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
wrote:
> Al
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 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 timing loop to wait f
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.
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,
>
>
>
> When I use a command like:
>
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 arr
Mike,
An expression inside parentheses on the right sign of the operator in the
condition is -- by design, I think -- not used for indexed retrieval, but
for row-by-row comparisions. (On the other hand "WHERE (columnname >
.vdate)" would be able to use an index.
This is a very useful thing to kno
set var clrd TEXT = (.class + ctxt(.tround))
(sent from Moto X2)
On Mar 23, 2016 9:07 PM, "dkfowler6179" wrote:
> Using 9.5/32 latest version.
>
> I need to "build" a variable name using input from a user. An example of
> what I'm looking for without the user input part is below.
>
> If variab
36 matches
Mail list logo
