Because when you put the calculation in the command it has to evaluate it for
each row.
Dan Goldberg
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Michael J. Sinclair
Sent: Thursday, June 2, 2016 3:48 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - speeding
Hi all,
I was doing a search of a two table view with about 1 million rows.The column I
am using has an index. This search was very slow.
BROWSE ALL FROM viewname WHERE columname > (.#date - 365)
This search was almost instant
SET VAR vdate = (.#date - 365)BROWSE ALL FROM viewname WHERE
At 09:44 AM 6/1/2016, Hodges, Dennis wrote:
The F9 key is a delete. It deletes and places the focus on the
previous record.
I want to delete and place focus on the next record. There are
occasions in my
application that several records need to be deleted and this would reduce the
steps
3 matches
Mail list logo